G
Guest
I need to know how to round the sum of a cell up to the nearest 500. Can
anyone help me with this?? I would appreciate it. Thanks.
anyone help me with this?? I would appreciate it. Thanks.
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.
G
Guest
Try something like this:
=ROUNDUP(SUM(A1:A100)/500,0)*500
HTH,
Elkar
=ROUNDUP(SUM(A1:A100)/500,0)*500
HTH,
Elkar
G
Guest
Try this:
With
A1: (a number)
This formula rounds the value in A1 UP, in increments of 500
B1: =CEILING(A1,500)
Does that help?
***********
Regards,
Ron
XL2002, WinXP
With
A1: (a number)
This formula rounds the value in A1 UP, in increments of 500
B1: =CEILING(A1,500)
Does that help?
***********
Regards,
Ron
XL2002, WinXP
D
David Biddulph
=CEILING(A1,500)
B
Bob Phillips
Do you mean sum and round in one go?
=CEILING(SUM(A1:A20),500)
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
=CEILING(SUM(A1:A20),500)
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)