SUMIFs function

L

lefty

Hi, I need some help on a spreadsheet my boss has asked me to design at work.
I work for retail company which pays its employees based on their sales.

Employee Monthly sales Total Payment
Jane $5,000 (Need Formula Here)

My formula is to be = If sales less than $1,000 a month they receive 5% of
their sales amount. If sales $1,000 - $5,000 they receive 10% of sales. If
sales $5,001 and up they receiv e 12% of sales. PLEASE HELP.

I've tried a SUMIFS function but I can't get it right. Should this have OR
in it perhaps?

Thanks,

Lefty
 
G

Gord Dibben

This should work for you entered in C2 and copied down assuming you have
more than one employee.

=LOOKUP(B2,{0,1000,5001},{0.05,0.1,0.12})*B2


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIFS function 4
Formula to obtain result from non exact sequence match 2
I need a function to update sales/expenses based on previous tota. 2
Formula, Pivot Table, ??? Beats me 2
Help with countif and sumif functions 8
Sumif as a fuction of If using multiple criteria 2
convert negative numbers to a zero 10
If Function - Date Problem 2

Top