Rounding
Try
=IF(A1<10,ROUND(A1,1),IF(A1<50,ROUND(A1*2,0)/2,ROUND(A1,0)))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Graham Aird" wrote in message
...
I have a long list of £ prices. I want to round anything under £10.00 to
the
nearest 10p (easy) I want to round anything over £50 to the nearest £1
(easy
again) but I need to round anything £10 and <£50 to the nearest (up or
down) to the nearest £0.50p.
Any Ideas? I've tried mROUND but can't get it to work!
Thanks in advance.
G
|