Rounding off

[chhatwal26]

how to round a cell value to next number if greater then .5 and round down if less then .5
113.55 TO 114
1255.36 TO 1255
1258.96 TO 1259
1457.26 TO 1457

[acerrhod]

Try this
=round(number,0)

[chhatwal26]

But this does not works i want like this
113.55 to 114
1255.36 to 1255
1258.96 to 1259
1457.26 to 1457
round up if decimal value is greater then .5 and round down if value is less then .5

[acerrhod]

that is strange, see the attached sample

[arthurbr]

You might want to try again, acerrhod's answer is what you asked for

[chhatwal26]

Thanks it worked pls help on this also
i have applied this formula on the cell =E14/31*D14 and i want the rounding value in the same cell.how to apply formula on this

[acerrhod]

try this:
=Round(E14/31*D14,0)

[chhatwal26]

thanks a lot