Rounding Numbers in Excel.

Discussion in 'Mac Apps and Mac App Store' started by Dal123, Nov 28, 2009.

  1. Dal123 macrumors 6502a

    Dal123

    Joined:
    Oct 23, 2008
    Location:
    England
    #1
    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 :eek:.
    Input is appreciated.:)
     

    Attached Files:

  2. Eraserhead macrumors G4

    Eraserhead

    Joined:
    Nov 3, 2005
    Location:
    UK
    #2
    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 :).
     
  3. Dal123 thread starter macrumors 6502a

    Dal123

    Joined:
    Oct 23, 2008
    Location:
    England
    #3
    Thanks Eraserhead, now I know what functions to use. Thanks buddy :D.
     

Share This Page