Profile cover photo
Profile photo
Peter Guilliatt
21 followers
21 followers
About
Peter's posts

Post has attachment

Post has attachment

Post has attachment

Post has attachment
A picture which may or may not explain nesting IF statements.

When I need to create a new formula which might contain nested formulas I always start with typing the following

=(test,true,false)

I then edit the text for each part. Doing it in the this logical (to me) manner helps be build up the correct number of brackets and sections of the statements.

if the first true/false result requires another 'if' statement I'd use the following

=(test1,if(test2,true2,false2),false1)

or

=(test1,true1,if(test2,true2,false2))

The number of nests allowed depends on the flavour of Excel being used.
Photo
Wait while more posts are being loaded