At present, I'm using a tried and trusted formula for rounding prices in
Excel (from the G2 cell) to either .50 or .95 as follows:
=ROUNDDOWN(G2+0.041,0)+IF(G2-ROUNDDOWN(G2+0.041,0)=0.5,0.95,0.5)
I've now been asked if an exception can be made to the formula for prices of
100+ which rounds down to the nearest whole unit, i.e. 101.95 becomes 101,
503.59 becomes 503 and so on.
Any help appreciated.
Regards
Alex McCourty
E-mail: