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

Best Black Friday Deals 2017

How modern book design was influenced by illustrated manuscripts

Best Black Friday Apple Deals 2017

Les meilleurs logiciels de montage vidéo gratuits (en 2017)