Tag: IF

Further to my recent post Business Model Renovation below is one of my ‘quick and dirty’ but handy and versatile macros I used in this project. It has been written this way because as I made changes to formulas in …

Business Model Renovation – Macros Read More »

Tagged with: , , , , , ,

We have all done them but there comes a time to find a better way.  In Excel 2003 you were limited to 7 levels of nesting but 2007 onwards the level could be increased to 64. Both these levels are …

Avoiding Nested IFs Read More »

Tagged with: , , ,