Excel 'IF' formula issue

[FLOGINEEDHELP]

Hi,

Im having an issue with the formula below...

If cell B25 has 'OPTION1' or 'OPTION2' in it, they should return the same result as the formulas are the same, but currently they do not. I assume i have misplaced a bracket, any help greatly appreciated

thanks in advance

=SUM((I45/(1+(F45/100)))-IF($B$25="OPTION1",(N45-(P45/2))),IF($B$25="OPTION2",(N45-(P45/2))))/((I45/(1+(F45/100))))

 

[CWatts]

Without knowing exactly what you want to it's a little tough to follow the formula, but it looks like you are closing your IF statements before you are entering the if_false condition.

If the box will ONLY have Option 1 or option 2, you can use the following expression:

IF($B$25="OPTION1",option_1_formula,not_option_1_formula)

If the box could have something other than option 1 or 2 then, you'd need something like this:

IF($B$25="OPTION1",option_1_formula,IF($B$25="OPTION2",option_2_formula,if_both_are_false_formula))

 

[jasonb75]

At a guess I would say

=SUM((I45/(1+(F45/100)))-IF($B$25="OPTION1",(N45-(P45/2)),IF($B$25="OPTION2",(N45-(P45/2)))))/((I45/(1+(F45/100))))

 

[chuckles1066]

=sum((i45/(1+(f45/100)))-if($b$25="option1",(n45-(p45/2)),if($b$25="option2",(n45-(p45/2))))/((i45/(1+(f45/100)))))

 

[AlphaFrog]

One more guess...

=(I45/(1+F45/100)-IF($B$25="OPTION1",N45-P45/2,N45-P45/2)) / (I45/(1+F45/100))