laika222
3/17/2017 - 2:22 PM

=IF(Logical Test,Place this value if true, ELSE place this value). You can nest another IF statement in the ELSE part of the formula, and ke

=IF(Logical Test,Place this value if true, ELSE place this value). You can nest another IF statement in the ELSE part of the formula, and keep going to infinity. In the final IF, place the final ELSE at the end to tell it what value to use if none of the conditions are met (in the basic NESTED statement on line 8, see the "No Match" for the location of the ELSE in the final IF statement). In the end, the number of ) symbols must equal the number of IF statements you have nested. For instance, if you have five IF statements, you'll end it with ))))).

IF STATEMENT NESTED
content_copyfile_download
--BASIC IF STATEMENT, PLACES 1 IF VALUE IS "BLUE", ELSE PLACES A VALUE OF 2

=IF(BE2="BLUE",1,2)


--BASIC NESTED IF STATEMENT

=IF(BE2="BLUE",0,IF(BE2="RED",1,"No Match"))


--COMPLICATED STATEMENT WITH 21 IF CLAUSES

=IF(BH6136="Unable to rate",0,IF(BH6136="< $1K",1,IF(BH6136="$1K - $2K",2,IF(BH6136="$2K - $3K",3,IF(BH6136="$3K - $5K",4,IF(BH6136="$5K - $7.5K",5,IF(BH6136="$7.5K - $10K",6,IF(BH6136="$10K - $15K",7,IF(BH6136="$15K - $20K",8,IF(BH6136="$20K - $25k",9,IF(BH6136="$25K - $30K",10,IF(BH6136="$30K - $40K",11,IF(BH6136="$40K - $50K",12,IF(BH6136="$50K - $75K",13,IF(BH6136="$75K - $100K",14,IF(BH6136="$100K - $200K",15,IF(BH6136="$200K - $300K",16,IF(BH6136="$300K - $500K",17,IF(BH6136="$500K - $1MM",18,IF(BH6136="$1MM - $5MM",19,IF(BH6136="$5MM+",20,"")))))))))))))))))))))