if and statements additions

[stoke]

=IF(AND(D11=0,G11=0),"0%",(G11-D11)/D11)

i have the above formula - how do i ensure that if D11=0 and G10 = >0 i get a result of 100%?
whilst maintaining the above formula?

i think that i need to add in an additional if statement but not sure how?

Thank you,

 

[ETID]

=if(and(d11=0,g10>0),"100%",IF(AND(D11=0,G11=0),"0%",(G11-D11)/D11))

 

[sfvb]

I can't say I agree with what you that the %increase from zero to a non zero number is 100%, but ...

=IF(D11=0,ABS(SIGN(G11)),(G11-D11)/D11)

will work.

Steve

 

[sfvb]

I guess if you think of any increase over 0 a %100 increase, then you would think of any decrease over 0 a 100% decrease. In that case...

=IF(D11=0,SIGN(G11),(G11-D11)/D11)

will work.

Steve

 

[stoke]

Thank you very much guys -i really appreciate your help.