# Solved Nested if returning false July 20, 2012 at 11:49:38
Specs: Windows XP
 I am using a nested if statement to determine the date and amount of an investment. The function works in the affirmative but returns false otherwise. I have put 0 as the last value so not sure why I am getting false.Formula:=IF(\$J12=L\$10,IF(\$G12="B",Assumptions!\$E\$17,IF(CapEx!\$G12="H",Assumptions!\$F\$17,IF(CapEx!\$G12="L",Assumptions!\$G\$17,0)))) See More: Nested if returning false

#1 July 20, 2012 at 12:56:07
 `=IF(\$J12=L\$10,IF(\$G12="B",Assumptions!\$E\$17,IF(CapEx!\$G12="H",Assumptions!\$F\$17,IF(CapEx!\$G12="L",Assumptions!\$G\$17,0))),0)`

Report •

#2
July 20, 2012 at 12:59:08
 Perfect! Thanks!!

Report •

#3 July 20, 2012 at 13:15:18
 When an IF function returns FALSE, it means that you have not specified a value _if_false to be returned for that logical_test.Here's what you have:IF J12 = L10, test G12 = "B"IF G12 = B return Assumptions!\$E\$17IF G12 <> "B", test CapEx!\$G12 = "H"IF CapEx!\$G12 = "H" return Assumptions!\$F\$17IF CapEx!\$G12 <> "H" test CapEx!\$G12 = "L"IF CapEx!\$G12 = "L" return Assumptions!\$G\$17IF CapEx!\$G12 <> "L" return 0You don't have a value_if_false argument for when J12 <> L10.What do you want returned when J12 <> L10Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

#4
July 20, 2012 at 13:36:16
 when J12 <> L10 the return should be 0.

Report •

#5 July 20, 2012 at 15:16:29
 ...and now you know why it didn't! ;-)Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report • 