IF

Business Model Renovation Macros Used

Further to my recent post this is one of the Business Model Renovation macros used in this project what I call one of my ‘quick and dirty’ but handy and versatile macros. It has been written this way because as I made changes to formulas in the templates I would just wanted to copy these […]

Business Model Renovation Macros Used Read More »

Avoiding Nested IFs

Formulas

Nested IFs. 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 beyond my pain barrier for an overly complex formula fraught with danger. Even

Avoiding Nested IFs Read More »