ROOUNDUP - to nearest 500 ???
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 ... ) |
ROOUNDUP - to nearest 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 ... ) |
ROOUNDUP - to nearest 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 ... ) |
All times are GMT +1. The time now is 10:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com