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