How do I tell a price list to round up and down to the nearest 25
=ROUND(A21*4,0)/4
where A21 holds the amount
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Philippa" wrote in message
...
I have created a price list in excel but the amounts are coming out at say
£25.68 and I would like to tell it to round up or down to the nearest 25p
can
I do this
|