Rounding up

[Safequip]

Hi I want to round my figures up to the nearest 0.50p or £1.00 but so far I can only work out how to round to nearest 0.50p by using =CEILING(P364,0.5) anyone help me with what I'm missing? As always thanks in advance.

 

[Somendra Misra]

Hi Safequip,

can you give some more examples of value and round up result.

Regards,

 

[oldchippy]

Hi Safequip,

How about

=ROUNDUP(A1*2,0)/2

or

=MROUND(A1+0.24999999,0.5)

 

[amp_82]

This will round to the nearest .50 so 1.49 becomes 1.50, 1.24 becomes 1.00, 1.75 becomes 2.00 etc.

=ROUND(A1*2,0)/2

 

[kchiba]

Try this, it rounds anything below .5 to x.50 and anything above to the next whole number

=IF(MOD(A1,1)>0.5,ROUNDUP(A1,0),ROUNDDOWN(A1,0)+0.5)

kanti