I need to create a formula that rounds up to the nearest $5 or $0

$533.35 would round to $535

$537.42 would round to $540

Thank you

I need to create a formula that rounds up to the nearest $5 or $0

$533.35 would round to $535

$537.42 would round to $540

Thank you

Ceiling is not a good solution if you want symmetry between negative and positive values. If the initial value is $6 it rounds to $10. When dealing with negatives you probably want $6 to round to $10. In that way, $6 and -$6 will generate $10 and -$10. If you use Ceiling you end up with $10 and -$5.

Hi David,

Thank you so much for your input..... the formula almost works.... here are my numbers and the formulas I have entered.

Stocking Dealer $1080

Wholesale 5 * Ceiling ( (Stocking Dealer * 1.116)/ 5 ) calculated at $1210 which is correct

Designer 5 * Ceiling ( (Stocking Dealer * 1.268)/ 5 ) calculated at $1369 I need it to be $1370

Retail 5 * Ceiling ( (Stocking Dealer * 3.41)/ 5 ) calculated at $3683 I need it to be $3685

I need all calculations to end in either a 0 or a 5

Thanks again for your help

Regards,

John Williams

Tel 909.969.1173

Fax 909.266.0364

Hi Malcom,

I tried the ceiling function and here is what I got.... Also i will always round up and there will be no negative numbers.

Stocking Dealer $1080

Wholesale 5 * Ceiling ( (Stocking Dealer * 1.116)/ 5 ) calculated at $1210 which is correct

Designer 5 * Ceiling ( (Stocking Dealer * 1.268)/ 5 ) calculated at $1369 I need it to be $1370

Retail 5 * Ceiling ( (Stocking Dealer * 3.41)/ 5 ) calculated at $3683 I need it to be $3685

I need all calculations to end in either a 0 or a 5

Can you recommend a solution?

Regards,

John Williams

Tel 909.969.1173

Fax 909.266.0364

Regards,

John Williams

Tel 909.969.1173

Fax 909.266.0364

Hi,

this doesn't work for negative numbers, but for positive values ...

= 5 * Round(table::aNumber / 5; 0)