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
|