Excel Roundup Help Needed

  Legslip 16:52 27 Jan 11

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 11



  uk-wizard 18:05 27 Jan 11

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 11

Thanks Vog

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

  Legslip 12:06 28 Jan 11

Cheers Vog, works a treat.

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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5