Set a percentage

  • Thread starter Thread starter TechnoGram
  • Start date Start date
T

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
 
=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)
 
=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 -
Click to expand...

- Show quoted text -
Click to expand...

thanks worked ... just do not understand the custom format thing too
well .. can you explain the use of custom format?
 
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)



TechnoGram said:
=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 -
Click to expand...

- Show quoted text -
Click to expand...

thanks worked ... just do not understand the custom format thing too
well .. can you explain the use of custom format?
Click to expand...
 
Back
Top