Excel rounding of prices

  butch 21:16 03 Nov 05
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 05

=ROUNDDOWN(A1*4,0)/4

  butch 21:40 03 Nov 05

Thanks for the help VoG you have saved my bacon

Kbutch

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

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch