Set a percentage

[TechnoGram]

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

 

[Bob Phillips]

=B1/A1-1

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

--
---
HTH

Bob

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

 

[TechnoGram]

=B1/A1-1

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

--
---
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- Hide quoted text -

- Show quoted text -

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

 

[Bob Phillips]

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

--
---
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

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

--
---
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- Hide quoted text -

- Show quoted text -

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