Percentage comparison

Posted by john on June 26, 2001 10:10 AM

What is the formula to get a percentage of two sales numbers?

As an example if B6 was 100 dollars and C6 was 80 dollars. D6 should read the difference was -%20.

Thanks for your help.

Posted by IML on June 26, 2001 10:13 AM

Chris

Lets these 2 cells be A1 and B1.

In C1 enter: ==AND(LEN(A1)=0,LEN(B1)=0)

Aladin

Posted by Aladin Akyurek on June 26, 2001 10:20 AM

Apparently my ghost has eaten up your reply here... Please repost

Posted by Russell on June 26, 2001 10:26 AM

I think weird things are going on with this board. The formula in D6 should read:

=(C6-B6)/B6

(and of cours format the cell as percentage)

Hope it helps,

Russell

Posted by IML on June 26, 2001 10:38 AM

Please keep your ghost on a tighter leash! haha

Posted by john on June 26, 2001 10:53 AM

Russell,
Thanks for your quick response! It works.

Thanks.