Hi Neil!

Try:
=CEILING(A1,5)-0.05

But you need to satisfy yourself on what happens to prices of (eg)
124.95 and 125

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Neil Mcknight" wrote in message
m...
I have a client who is trying to price his shop stock using Excel.

The problem is that he has taken his cost price and multiplied it by
his markup, which is an easy formula.

He is now left with his selling price, but what he wants to do is
round the selling price up to either the nearest £5 or £10 and
subtract 5p.
To explain this further, if his exact selling price is £123.45 he
wants to round this up to £124.95, but if his exact selling price is
£125.67 he wants to round this up to £130.95.

Does anyone know how to do this formula in Excel, in words it will
basically say if below pounds ending in the multiples of 5, round up
and subtract 5p. But if above pounds ending in 5 round up to the
nearest 10 and subtract 5p.

I hope this makes sense, but I just can't find a formula that works

Thanks in advance

Neil.