Excel rounding of prices

  butch 21:16 03 Nov 05

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


  butch 21:40 03 Nov 05

Thanks for the help VoG you have saved my bacon


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…