Find all IF functions

Find all IF functions

IF functions can be particularly risky and are generally important cells. Did the person put the correct sign in (was it > but it should have been >=)? Have they built the correct TRUE/ FALSE outputs?

Double IF’s are even more dangerous and worse is when you get to 3 or 4 levels. These cells need careful review to make sure that they are right in all the possible outcomes.

Note: if you have stumbled onto this page it would be best if you started at the beginning

Below a video clip explaining what this test in Spreadsheet Professional means

 

Purchase Spreadsheet Professional

 

Back to: Auditing an Excel spreadsheet > Prioritise which formula to look in for errors