Profile

Cover photo
Peter Guilliatt
21 followers|148,470 views
AboutPostsPhotosYouTube

Stream

Peter Guilliatt

Discussion  - 
 
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.
16
1
Yitzchok Stern, EA (Enrolled Agent)'s profile photo
Add a comment...
Have them in circles
21 people
Krishnanu Ray's profile photo
ayan mallick's profile photo
Vicki Shelley's profile photo
Eileen O'Brien's profile photo
Paul Spencer's profile photo
caitlin pink's profile photo
Derrick Guilliatt's profile photo
Yoko E Golding G's profile photo
Luke Maltby's profile photo
People
Have them in circles
21 people
Krishnanu Ray's profile photo
ayan mallick's profile photo
Vicki Shelley's profile photo
Eileen O'Brien's profile photo
Paul Spencer's profile photo
caitlin pink's profile photo
Derrick Guilliatt's profile photo
Yoko E Golding G's profile photo
Luke Maltby's profile photo
Links