Excel rounding of prices

  butch 21:16 03 Nov 2005
Locked

Does anyone know a method of rounding down prices to the nearest 25p eg £25.48 would become £25.25 and £65.67 would be £65.50 etc.

I have done this with older versions of excel but I cannot seem to do it with excel 2003 Regards kbutch

  VoG II 21:32 03 Nov 2005

=ROUNDDOWN(A1*4,0)/4

  butch 21:40 03 Nov 2005

Thanks for the help VoG you have saved my bacon

Kbutch

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?