On Apr 10, 7:22 am, JN wrote:
"joeu2004" wrote:
On Apr 9, 4:38 pm, JN wrote:
Try the following:
=if(B1=0, if(C1=0, 0%, 100%), C1/B1 - 1)

I was trying to calculate the difference between 2 #s as a percentage and was
using the above formula with the IF statement

HOWEVER you provided me with perfection and I'm very, very happy! Thank you
so much!

You're welcome! Glad to hear that works well for you. FYI, here is
another expression of the same solution. Use whichever one is easier
for you to use:

=if(B1=0, (C1<0)*100%, C1/B1 - 1)