Variable commission calculation

**leppard77** · 10-01-2009, 02:30 PM

If anyone can help me with a problem I would be grateful

I am trying to figure a commission in a cell that is variable dependent on the data in another cell.

The commission earned (cell O3) will be either 10, 8 or 5% depending on what value cell L3 shows. If L3 shows $3.00 or higher than O3 needs to calculate 10% of cell K3, if L3 shows $2.80-$2.99 then O3 needs to calculate 8% of K3 and if L3 shows $2.60-$2.79 O3 needs to calculate 5% of K3.

Hopefully I've explained what I'm trying to do well enough, thanks for any help I can get in advance!

**JBeaucaire** · 10-01-2009, 02:33 PM

So, something like this in O3:

=K3 * LOOKUP(L3, {2.6,2.8,3},{0.05,0.08,0.1})

**leppard77** · 10-01-2009, 03:14 PM

Awesome, that's perfect. Thank you very much

**JBeaucaire** · 10-01-2009, 03:35 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)