help with nested if statement....

[smilesci]

Here is my current formula:
=IF(AND(((D16-K16)/K16*100)>-0.5,((D16-K16)/K16*100)<0.5),0,(D16-K16)/K16*100)

I need an additional condition on top of this that states if K16=0, to give me a value of zero in the cell and disregard the rest of the statement. I cannot figure out how to get an addition OR statement added to this formula. Can anyone help?

Thanks!
Meg

 

[Tazguy37]

How about this?:
=IF(K16=0,0,IF(AND(((D16-K16)/K16*100)>-0.5,((D16-K16)/K16*100)<0.5),0,(D16-K16)/K16*100))

Hope that helps!

 

[Oaktree]

Welcome to the board!

Just add IF(K16=0,0, rest of formula) around the formula you posted for:

=IF(K16=0,0,IF(AND(((D16-K16)/K16*100)>-0.5,((D16-K16)/K16*100)<0.5),0,(D16-K16)/K16*100))

Edit: Too slow for Taz

 

[IML]

You could shorten this a bit with
=IF(K16,IF(ABS((D16-K16)/K16)<0.05,0,(D16-K16)/K16*100),0)

still playing
=IF(K16,IF(ABS((D16/K16)-1)<0.005,0,((D16/K16)-1)*100),0)

 

[smilesci]

Thanks!! You guys rock!