I'm trying to enter a calculation that will show me the difference between
two cells with the result being a percentage.

as in;

269751.59 - $306,652.22 = $(36,900.63)

I want to display this as a percentage but I'm not sure how to format it to
show it that way.

Thanks,

Miranda

Hi
=(A1-B1)/A1
and format as percentage

"Miranda" wrote:

I'm trying to enter a calculation that will show me the difference between
two cells with the result being a percentage.

as in;

269751.59 - $306,652.22 = $(36,900.63)

I want to display this as a percentage but I'm not sure how to format it to
show it that way.

Thanks,

Miranda

Maybe you want to re-think this. Subtraction does not yield a percentage.
if you want to divide use /

--
Don Guillett
SalesAid Software

"Miranda" wrote in message
...
I'm trying to enter a calculation that will show me the difference between
two cells with the result being a percentage.

as in;

269751.59 - $306,652.22 = $(36,900.63)

I want to display this as a percentage but I'm not sure how to format it
to
show it that way.

Thanks,

Miranda