2 responses

  1. CDV
    May 30, 2012

    B4 is value
    C4 =IF(MOD(B4*100,100)<50, FLOOR(B4,1),CEILING(B4,1))

  2. hot-n-cool
    May 30, 2012

    There are many options, some of them is given below:

    Option A: Format the cell as number or currency without decimal places. For doing so follow this – Format > cell.

    Option B: Write in the cell =round(416.75,0), the result will come without decimals, i.e., 417.

    Option C: Use functions like Floor or Ceiling.

    Option D: for any clarification mail me at [email protected]

Leave a Reply




Back to top
mobile desktop