how do I enter this in excel sumif

K

kiki

enter formulas to calulate the total for each sale and the amount of
commission earned by each sale using the following information:
House sold for 138000
House sold for 200000
if house sold for >100000<149999 recieve 0.5% commission
if house sold for >150000<199999 recieve 1.0% commission
if house sold for >200000 recieve 1.5% commission
bonus $2000 if total sales >10000
 
M

Ms-Exl-Learner

Assume that your sales values are in B Column. Copy and paste the below
formula in C1 cell.

=IF(B1>200000,B1*1.5%,IF(B1>150000,B1*1%,IF(B1>100000,B1*0.5%,"")))

I am not clear about your final statement “bonus $2000 if total sales >10000â€.
 
R

Roger Govier

Hi

One way, with house value in A1
=MAX(0,A1-100000)*0.5%+MAX(0,A1-149999)*0.5%+MAX(0,A1-199999)*0.5%
 

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

how to get a percentage total in excel chart 2
Need Help with Sumif Function including dates 6
How do I determine 10
Create a complex running total by month on a report. 0
how do i enter the formula? 3
Excel nested IF formula question 6
Need offset function help, I think 0
How do I do this? 6

Top