Thread: percentages
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
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