Forum Home
Press F1
 
Thread ID: 5604 2000-09-04 04:18:00 formula help Guest (0) Press F1
Post ID Timestamp Content User
6186 2000-09-04 04:18:00 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. 		Guest (0)
1