S
sruarg
i would like to round a currency amount to the next $ 0.05 (five cents)
eg 30.63 to be 30.65 or 40.48 to be 40.50
eg 30.63 to be 30.65 or 40.48 to be 40.50
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
×
מיכ×ל (מיקי) ×בידן
Try using the CEILING Function.
Micky
Micky
J
Jeff Jensen
Next five cents:
=ROUNDUP(A1/0.05,0)*0.05
Nearest five cents:
=ROUND(A1/0.05,0)*0.05
=ROUNDUP(A1/0.05,0)*0.05
Nearest five cents:
=ROUND(A1/0.05,0)*0.05
L
Lars-Åke Aspelin
i would like to round a currency amount to the next $ 0.05 (five cents)
eg 30.63 to be 30.65 or 40.48 to be 40.50
Try this formula:
=MROUND(A1+0.2499, 0.05)
Hope this helps / Lars-Åke
J
Jeff Jensen
I forgot something...
Next five cents:
=ROUNDUP(A1/0.05,0)*0.05
=CEILING(A1,0.05)
Nearest five cents:
=ROUND(A1/0.05,0)*0.05
Next five cents:
=ROUNDUP(A1/0.05,0)*0.05
=CEILING(A1,0.05)
Nearest five cents:
=ROUND(A1/0.05,0)*0.05