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