I can round a number up to the next digit, the next ten or the next 100 or
the next 1000 ... but not to the next 500 .... in a spreadsheet in use for
estimating quotes for heating installations - anyone any ideas?

(Practical application is:- clips for holding underfloor heating pipe in
place - 1 per meter, but they come in boxes of 500, so if there is 2310
meters of pipe going to a job, that needs 5 boxes of 500 ... )

=CEILING(A1,500)


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Garry Kennedy" wrote in message
...
I can round a number up to the next digit, the next ten or the next 100 or
the next 1000 ... but not to the next 500 .... in a spreadsheet in use for
estimating quotes for heating installations - anyone any ideas?

(Practical application is:- clips for holding underfloor heating pipe in
place - 1 per meter, but they come in boxes of 500, so if there is 2310
meters of pipe going to a job, that needs 5 boxes of 500 ... )

Have a look at the CEILING function.

Hope this helps.

Pete

On Dec 21, 4:07*pm, "Garry Kennedy" wrote:
I can round a number up to the next digit, the next ten or the next 100 or
the next 1000 ... but not to the next 500 .... in a spreadsheet in use for
estimating quotes for heating installations - anyone any ideas?

(Practical application is:- clips for holding underfloor heating pipe in
place *- 1 per meter, but they come in boxes of 500, so if there is 2310
meters of pipe going to a job, that needs 5 boxes of 500 ... )