round up to the next 5p

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Can Anyone help.

Excel 2k

I need a formula to round up to the next £ 0.05, ie:

From £ 0.92 to £ 0.95
From £ 0.01 to £ 0.05
From £ 1.27 to £ 1.30

Many thanks in advance

Simon
 
Hi Simon,

Try:
=roundup(value/0.05,0)*0.05

Cheers


Can Anyone help.

Excel 2k

I need a formula to round up to the next £ 0.05, ie:

From £ 0.92 to £ 0.95
From £ 0.01 to £ 0.05
From £ 1.27 to £ 1.30

Many thanks in advance

Simon
 
Superb , many thanks .

Cheeky request, is there a formula to round down to the
nearest .05

Cheers

Simon
-----Original Message-----
Or the somewhat more efficient

=CEILING(A1,0.05)
Click to expand...
 
Back
Top