Trying to create a Commission Spread Sheet

[Ozzysun]

I'm trying to figure out my commission structure for a spreadsheet.

If I get 12 of a certain sale I receive 100$, if I get 15 I get 150.
I would like to have a cell that can calculate if i get 12 it shows 100, if I get 15 it changes to 150.

Can anyone please help me with this.

Thank you,

[MarvinP]

Hey Ozzysun, welcome to the forum,

This is a problem for a VLookup using True and a Lookup Table. See the example attached.

Vlookup True Commission Scale.xlsx

Change the 12 to a 10 in the table and watch what happens...

[Logit]

.
Or .. if you are only wanting a formula for a single cell try :

Please Login or Register  to view this content.

This assumes you are entering the total number of items sold in Cell A1. You can edit A1 in the formula to be any cell you need. The formula can be placed
in Cell B1 or any cell other than A1 (or the cell you chose for entering total units sold).

Format the cell with the formula as CURRENCY.