Hi,

We have a price tool where we add a % margin to our buy price. Sometimes we need to sell something via an industry framework and if we're not on that framework we have to go through a provider that is. These providers charge us for it, usually a %. We send them a particular sheet that they copy the rows from into their own tool and add the %.

So what I need to be able to calculate is an appropriate reduction on our direct sale price so that when the framework provider adds their % back on, it equals the exact same value as our direct sale price, AND I need this all rounded to 2 decimal places. Because the customer seems our direct sale price and the framework provider price.

E.g.:

Unit Buy Price: $99.49
Our Margin: 5%
Framework Provider Charge: 2%
Unit Sale Price: $99.49 + 5% = $104.4645 (which would round to $104.46 with ROUND function)
Unit Framework Price: $104.46 - ??? = $102.41 (the result also needs to be rounded to 2 decimal places)
Framework Provider Quote: $102.41 + 2% = $104.4582 (which would round to $104.46 with ROUND function)

Then, I need the same thing for the total columns. Using the example above but quantity 5:

Unit Buy Price: $99.49 * 5 = $497.45
Our Margin: 5%
Framework Provider Charge: 2%
Unit Sale Price: $99.49 * 5 + 5% = $522.3225 (which would round to $522.32 with ROUND function)
Unit Framework Price: $522.32 - ??? = $512.08 (the result also needs to be rounded to 2 decimal places)
Framework Provider Quote: $512.08 + 2% = $522.3216 (which would round to $522.32 with ROUND function)

I hope that makes sense!

Thanks