Excel Roundup Help Needed

  Legslip 16:52 27 Jan 2011

I work in a small retail shop and the recent VAT changes have left us with prices with uncommercial pence additions i.e. £29.73 or £45.36 as examples.
Is there an excel formula for rounding up anything between .00p and .49p to .45p, and rounding up anything between .50p and .99p to .95p?
Hope you get the gist.

  VoG II 17:03 27 Jan 2011



  uk-wizard 18:05 27 Jan 2011

What!! I thought everything was £XX.99p *grin*

I know the problem I had to alter 4800 prices but I did it to the nearest 10p.

  Legslip 18:21 27 Jan 2011

Thanks Vog

Will try when I get to work tomorrow pm and report back.

  Legslip 12:06 28 Jan 2011

Cheers Vog, works a treat.

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

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

InVision Studio takes on Adobe XD and Sketch

Camera tips to take better iPhone photos

Comment transformer un iPhone en borne Wi-Fi ?