a little help pls

[irishcavan]

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

I am trying to calculate a retail cost based on my wholesale cost. Her
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 en
with .95

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

Best regards,
Irish Cava

 

[fontsie]

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,

 

[irishcavan]

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

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