#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default percentages

I have a price sheet in excel that i want to take the list price and copy it
and take off 40% off the whole list. What formula do i put in a blank cell to
take off 40%, also if i want to take off 44%,43% and so on.Please help, thank
you
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default percentages

Enter 0.6 in a blank cell, then right click in that cell and choose "Copy".
Select the list, and right click in that selection and choose "Paste
Special".
Click on "Multiply",
Then <OK <Esc
And you should be done.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"mowerman" wrote in message
...
I have a price sheet in excel that i want to take the list price and copy it
and take off 40% off the whole list. What formula do i put in a blank cell
to
take off 40%, also if i want to take off 44%,43% and so on.Please help,
thank
you


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default percentages

If you have a number (say 88) in A1 and use the formula =A1*(1-40%) in B1
then the result is 88 discounted by 40%. But I expect you want dollars and
cents to two decimal places so use =ROUND(=A1*(1-40%), 2)
With $88 either formula gives $52.80 but with $12.99 the first formula gives
$7.794 while the second give $7.79

You could type =(1-40%) in an empty cell; copy the cell; select the values
to discount; use Edit | Paste Special | Multiple. Now the values are
discounted but not rounded to 2 decimal places.

Be aware that formatting to display only 2 decimals does not alter the
actual stored value.

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"mowerman" wrote in message
...
I have a price sheet in excel that i want to take the list price and copy
it
and take off 40% off the whole list. What formula do i put in a blank cell
to
take off 40%, also if i want to take off 44%,43% and so on.Please help,
thank
you



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default percentages

=A1*(1-40%)


so you multiply any value with 0.6 to get 40% of the original price

you can also put that number in a cell and (do this on a copy of the list)
copy it, select all values and do editpaste special and select multiply


--


Regards,


Peo Sjoblom


"mowerman" wrote in message
...
I have a price sheet in excel that i want to take the list price and copy
it
and take off 40% off the whole list. What formula do i put in a blank cell
to
take off 40%, also if i want to take off 44%,43% and so on.Please help,
thank
you



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Percentages shalamar2007 Excel Worksheet Functions 1 May 11th 07 07:58 PM
percentages Mark Scott Excel Worksheet Functions 3 July 10th 06 12:09 AM
percentages chedd via OfficeKB.com Excel Worksheet Functions 5 June 12th 06 12:25 PM
Percentages Hotpants0063 Excel Worksheet Functions 4 April 10th 06 10:30 PM
Percentages trev2283 Excel Worksheet Functions 1 November 5th 05 07:30 PM


All times are GMT +1. The time now is 09:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"