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

Report •


#1
July 20, 2012 at 12:56:07
✔ Best Answer
=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)

How To Ask Questions The Smart Way


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$17

IF G12 <> "B", test CapEx!$G12 = "H"

IF CapEx!$G12 = "H" return Assumptions!$F$17

IF CapEx!$G12 <> "H" test CapEx!$G12 = "L"

IF CapEx!$G12 = "L" return Assumptions!$G$17

IF CapEx!$G12 <> "L" return 0

You don't have a value_if_false argument for when J12 <> L10.

What do you want returned when J12 <> L10

Click 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

Report •


Ask Question