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.

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.