How to nest an If statement in an if statement

Question

I have a cell that I want to calculate this if statement =IF(E7>D7,E7-D7,D7-E7) but only if the Cell G7 is yes.

I wrote this formula =IF(G7=yes,(IF(E7>D7,E7-D7,D7-E7)),"n/a") but it doesn't work, how would I fix it?

@shelby, you are getting #Name error because in IF(G7=yes the yes is without quotes and it must be like "Yes" or "yes". Since it's without quotes, Excel considers it as Reserve word (Function/Command) and Excel does't have any !! — Rajesh Sinha, Commented Jul 5, 2019 at 7:07

cybernetic.nomad · Accepted Answer · 2019-07-04 17:09:55Z

4

You could also get the absolute value of the difference:

=IF(G7="yes",ABS(E7-D7), "n/a")

answered Jul 4, 2019 at 17:09

cybernetic.nomad

5,55613 silver badges25 bronze badges

Add a comment |

Humble Val · Accepted Answer · 2019-07-04 17:06:48Z

0

You don't need to add extra brackets for the nested IF statement. Try this:

=IF(G7="yes",IF(E7>D7,E7-D7,D7-E7), "n/a")

answered Jul 4, 2019 at 17:06

Humble Val

612 silver badges7 bronze badges

it removed the Name error, but even with Yes in G7, it still returns n/a
– shelby
Commented Jul 4, 2019 at 17:12
Odd. It's should be working snag.gy/xsBfD4.jpg. Start a new sheet and try it again. The cell format might be irregular.
– Humble Val
Commented Jul 4, 2019 at 17:18
That worked, I had the yes and no options as a drop down menu, so i think that might have been the issue, once i got rid of that it woked..
– shelby
Commented Jul 4, 2019 at 17:54

Add a comment |

2 Answers 2