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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…