PDA

View Full Version : formula help



04-09-2000, 03:18 PM
SUM=(A1/100*33)+A1

I am using the above formula to extend prices as showen below.

$0.20>$0.27
$0.40>$0.53
$0.50>$0.67
$0.80>$1.06
$1.10>$1.46

I would like the formula to also round up or down to the nearest .05c or .10c as needed with results as below.

>>$0.30
>>$0.55
>>$0.70
>>$1.05
>>$1.45

Many thanks for any help.