round up to the next 5p

[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

 

[macropod]

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

 

[Ilan Rencus]

Try =(A1*100-MOD(A1*100,5)+5)/100
Ilan

 

[Peo Sjoblom]

Or the somewhat more efficient

=CEILING(A1,0.05)

 

[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)

 

[JE McGimpsey]

Try:

=FLOOR(A1, 0.05)

Superb , many thanks .

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

Cheers

Simon