Cost to Retail Price Formula - some help pse

[Eurbiz]

Hi
I multiply my cost price by 2.35 to arrive at my retail price which is
straight forward enough!

However I'd then like to round up each resultant retail price as
follows:

Retail price ending between .01 to 0.25 rounds up to 0.25
Retail price ending between .26 to 0.50 rounds up to 0.50
Retail price ending between .51 to 0.75 rounds up to 0.75
Retail price ending between .76 to 0.99 rounds up(down) to 0.95

E.G. $4.86 will show as $4.95

Could anyone help me with, I suspect, a complex formula to enable me to
do this?

Regards
Patrick

St Andrews
Scotland

 

[Guest]

Try:

=IF(MOD(A1,1)<=0.75,CEILING(A1,0.25),INT(A1)+0.95)

HTH

 

[Eurbiz]

Many thanks HTH

Thats perfect and saved me a great deal of time

much appreciated!

Patrick MacEwen
www.bonkers.uk.com