Cost to Retail Price Formula - some help pse
 

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


--
Eurbiz
------------------------------------------------------------------------
Eurbiz's Profile: http://www.excelforum.com/member.php...o&userid=34948
View this thread: http://www.excelforum.com/showthread...hreadid=546818

Cost to Retail Price Formula - some help pse
 

Try:

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

HTH

"Eurbiz" wrote:


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


--
Eurbiz
------------------------------------------------------------------------
Eurbiz's Profile: http://www.excelforum.com/member.php...o&userid=34948
View this thread: http://www.excelforum.com/showthread...hreadid=546818

Cost to Retail Price Formula - some help pse
 

Many thanks HTH

Thats perfect and saved me a great deal of time

much appreciated!

Patrick MacEwen
www.bonkers.uk.com


--
Eurbiz
------------------------------------------------------------------------
Eurbiz's Profile: http://www.excelforum.com/member.php...o&userid=34948
View this thread: http://www.excelforum.com/showthread...hreadid=546818