Rounding Numbers in Excel.

[Dal123]

A sheet of ply comes 1220mm wide and my staircase is 1200 wide. Therefore I get two out of one cut of ply. Used an 'if' function <1220 to divide by two as I get two out of one sheet if it's less than 1220.
Cell D11 calculates the amount of ply (as width measurement) needed by using an 'if' function, and E11 works it out as an actual sheet. The problem is it's showing 0.47 instead of rounding it to the nearest whole sheet (1), even if only 10mm is used I need to buy a whole sheet.
There is masses of work to be done here so not to worry about all the other stuff I have just discovered the 'if' function .
Input is appreciated.

 

[Eraserhead]

If you need to buy whole sheets of wood - i.e. if it is 10.1mm then you need 20mm. Then you need to use the CEILING function. If you need to always round down you use the FLOOR function. If you need to round to just the nearest "x number of digits" then you use the MROUND function.

To find out how they work, try taking a look at the Excel help .

 

[Dal123]

Thanks Eraserhead, now I know what functions to use. Thanks buddy .