Can someone make a simple spreadsheet for me?

Can someone make a spreadsheet for me (and others) that I can punch LindeX info into and it will tell me how much L$ I need to sell to cover $X.XX amount of fees, taking into consideration the selling fees? I've been trying to get one working, but I just cant get it to work right. I'm touched in the head today or something.

Example:

Dollars ......... 20
L$ per dollar........ 255
$L ........... 5100
Total needed........ 5278.5


Showing formulas:

Dollars ......... 20
L$ per dollar ........255
$L ........... =(+B2*B1)
Total needed ........ =B3+(B3*0.035)

I hope that's what you are looking for....

That's exactly what I needed. So simple. I was overcomplicating my formulas! Thanks!

You're welcome Aaron

I think the last calc needs to read like this.. =B3+(B3*0.035)+(B3*0.025)

Because you have to pay the commission on the commission lol.

It's not exact, but it's better

Hey Aaron,

I noticed my calculations were wrong, because it didn't take into account paying for the commission. I recalculated and came up with a better calculation


For the last calculation change =B3+(B3*0.035) to =B3+(B3*0.035)+(B3*0.0025). I think that will work. At least get closer.