No sorry, rounding to the nearest £10 should make £125 round up to £130.

Basically if it is under the nearest £5 round to it, but if it is over £5
then round to the nearest £10.

Eg 123.23 becomes 125
125.50 becomes £130

I hope this explains better.
Thanks

Neil.

On 3/4/04 11:51, in article , "Bob
Phillips" wrote:

Neil,

I can't figure out your example.£123.45 rounds up £5 to £125, that's fine.
But how does £125 rounding up £10 work out as £131? If it should be £135,
this should work

=ROUNDUP(A1/5,0)*5+((MOD(INT(A1),5)=0)*5)-0.05