Help with a formula

[gifford]

Hi guys,

I have a variety of products that i sell out to different agents at various levels of commissions. These range from a possible earning for the agents from 12%-30%.

Is there a set formula that will take my initial buying price ie £100 and i wish to earn £5 regardless of whether the agent earns 12% or 30%.

so an agent on 12% would buy from me at £119.32 and an agent on 30% would buy from me at £150

any ideas

cheers
gif

[zbor]

here it is

Buying price	Profit	Agebt fee	Selling price
100	5	0,2	=(B4+C4)/(1-D4)

Buying price	Profit	Agebt fee	Selling price
£100,00	£5,00	20%	131,25

[gifford]

so simple yet so far away from me

Thanks Zbor

[zbor]

Anytime.. don't forget to make thread [closed]