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

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

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

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