Hi, using Excel 2002 on XP.

My partner and I are selling products. He gets 5% of the sales price, then I get the rest. But I want to make at least $2 on every sale. So, let's say the item cost us $50. If he wants 5% off the top, and I want at least $2, how do we calculate what to sell it for?

I tried the following, but it didn't work:

$50 (cost)

+ $2 (my profit)

+ 5% (partner's profit)

------

$54.60 (sales price)

It doesn't work because I end up with $1.87.

$54.60 (sales price)

- 5% (partner's profit)

- 50 (cost)

------

$1.87 (my profit)

I've tried other things, but I always end up under $2. Is it possible to calculate this? or do I need to have a percentage for myself? If Excel can't do it, do you know of any calculators out there than can? Thanks.

## Bookmarks