#### Mndlssbrndlsm

##### New Member

- Joined
- Oct 1, 2011

- Messages
- 4

I hope someone can help me with a problem I'm facing.

I have a set amount of cash. Say 1000 (A1).

I want to calculate how many units I can buy with this 1000. The units trade at a price of 1.5 (B1).

However, the issue is that for purchasing these units I will need to pay a variable rate of commission. This commission is 1% of the purchase price, with a minimum of 2.5.

It is the variable rate of commission that is causing me difficulties as I cannot work out how to calculate the number of units I can buy without knowing the commission. And can't work out the commission without knowing the number of units I can buy

Does anyone know a rounddown (or similar) formula i could use to calculate this?

Apologies, this is more of a simple algebra problem then an excel one, but I just can't work this out.

Thanks in advance for any replies.