software

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: www.excelforum.com/member.php...oamp;userid=34281
View this thread: www.excelforum.com/showthread...hreadid=540457Hello,

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

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

Hope that helps,
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: www.excelforum.com/member.php...oamp;userid=34281
View this thread: www.excelforum.com/showthread...hreadid=540457