round up in units of 80!

Hi I have written a spread sheet and have been stumped by one part I need to work out the following.

It is for working out the measurements for roof battens in sheds and it needs to work on the following formula -

Width of shed 2400mm

I need to work out how long the batten has to be so the roof sheets fit evenly, the measurement has to start from 1460mm and go up in increments of 80mm eg 1540mm, 1620mm, 1700mm and so on. But the number has be closest increment of 80mm over the shed width if this makes sense, the size of the battens for 2400 width shed would be 2420mm but i need this to work out for any width shed not just 2400.

Is there a formula for this to be worked out in excell, if so please help.

Thanks Pricey74.

Have a look at CEILING

eg

=CEILING(value,80)

would round the value up to nearest multiple of 80.

so given you have a starting point (1460) perhaps: =1460+(CEILING(A1-1460,80))
where A1 holds width - eg 2400

alternatively given you know that base point is 20 over the nearest multiple of 80 (1440) you could use: =CEILING(A1,80)+20

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save