HI Chris,

Not nice but the best I could do

=IF(MOD(A1,0.1)*100<5,CEILING(A1,0.05),A1-MOD(A1,0.1)+0.09)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Chris Wetz" <Chris wrote in message
...
I want to round a series of numbers to the nearest price point of 5 or 9
pence (up or down). E.g. £12.74 would become £12.75, £12.78 would become
£12.79, £12.91 would become £12.89

Any ideas? I'm happy to use a series of calculations if there is no
single
function that will do the trick.

TIA,

Chris.