Set a percentage

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TechnoGram - 02 Dec 2007 00:41 GMT

I have a small worksheet that adds up sales in a year and compares it
to sales in the previous year. I also have a column showing the
difference in $ between the two. I would like to know the formula
required to get the fourth column to tell me the percent difference
between the two with a minus or loss showing in brackets and in red.
Thanks

Reply to this Message

Bob Phillips - 02 Dec 2007 01:06 GMT

=B1/A1-1

and use a custom format of %;[Red](%)

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I have a small worksheet that adds up sales in a year and compares it
> to sales in the previous year. I also have a column showing the
> difference in $ between the two. I would like to know the formula
> required to get the fourth column to tell me the percent difference
> between the two with a minus or loss showing in brackets and in red.
> Thanks

Reply to this Message

TechnoGram - 02 Dec 2007 23:11 GMT

> =B1/A1-1
>
[quoted text clipped - 16 lines]
>
> - Show quoted text -

thanks worked ... just do not understand the custom format thing too
well .. can you explain the use of custom format?

Reply to this Message

Bob Phillips - 02 Dec 2007 23:25 GMT

Plug 'Guidelines for custom number formats' into Excel help, and you should
get some good info.

Signature

---
HTH

Bob

__________________________________________
UK Cambridge XL Users Conference 29-30 Nov
http://www.exceluserconference.com/UKEUC.html

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>> =B1/A1-1
>>
[quoted text clipped - 20 lines]
> thanks worked ... just do not understand the custom format thing too
> well .. can you explain the use of custom format?

Reply to this Message