How do I tell a price list to round up and down to the nearest 25

[Guest]

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

 

[Domenic]

Try...

=ROUND(25.68/0.25,0)*0.25

Hope this helps!

 

[Bob Phillips]

=ROUND(A21*4,0)/4

where A21 holds the amount

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)