a little help pls
 

I have not had time to go throught all the postings in here, so if i am
repeating this question, i beg your forgiveness.

I am trying to calculate a retail cost based on my wholesale cost. Here
is what I am trying to achieve:

Here are three costs examples:

Wholesale x Increase by = Retail Cost
$ 4.95 400% $ 19.80
$ 49.95 200% $ 99.90
$ 79.95 175% $ 139.91

once the costs are established, I would like the Retail cost to end
with .95

I can use the IF function to calculate using two scenarios, but i can
not seem to get it to work with three scenarios. Any help would be
greatly appreciated.

Best regards,
Irish Cavan


--
irishcavan
------------------------------------------------------------------------
irishcavan's Profile: http://www.excelforum.com/member.php...o&userid=34281
View this thread: http://www.excelforum.com/showthread...hreadid=540457

a little help pls
 

Hello,

Do you mean that no matter what the cent value is, you want it to be
".95"?

In that case, how about using the Integer function:
C1=INT(A1*B1)+.95

Hope that helps,

a little help pls
 

thanks fontsie.. i already have the code for the .95 part. but
thanks..

i am more concernced with figuring out the calculation for the pricing.


--
irishcavan
------------------------------------------------------------------------
irishcavan's Profile: http://www.excelforum.com/member.php...o&userid=34281
View this thread: http://www.excelforum.com/showthread...hreadid=540457