percentages

  • Thread starter Thread starter mowerman
  • Start date Start date
M

mowerman

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

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
 
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
 
=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 edit>paste special and select multiply


--


Regards,


Peo Sjoblom
 
Back
Top