Hi,
I usually find what I am looking for in the forums but I am struggling to find any answers for my problem.
I have set up a large spreadsheet to calculate quantites of concrete and brickwork to new build houses and I am having trouble with rounding in one of my cells.
I am trying to calculate the area of bricks and blocks required to each house.
As an example if I have 600mm of total brickwork I know I will require a 225mm trench block, 225mm block and 150mm of brickwork. (Blocks are always 225mm and bricks are always 75mm)
To calculate the area of trench block required I need to take 600mm and deduct 225mm. I then need to divide this result and work out how many times 225mm goes in to it. In this example 600-225= 375. 375/225=1.667. So I need the answer to read 1.
I have tried FLOOR and ROUNDDOWN but where the answer is an equal number, i.e 450/225=2, it rounds it down by an additional 1. If I use MROUND it rounds the number up when I need it to round the number down, i.e 375/225=1.667 would equal 2.
I hope the above makes sense.
Thanks in advance
Marcus
Bookmarks