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
|