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.



See More: Nested if returning false

Report •

July 20, 2012 at 12:56:07
✔ Best Answer

How To Ask Questions The Smart Way

Report •

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

Report •

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

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

Report •

July 20, 2012 at 15:16:29

Report •

Ask Question