how do I enter this in excel sumif
 

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

how do I enter this in excel sumif
 

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

=IF(B1200000,B1*1.5%,IF(B1150000,B1*1%,IF(B1100 000,B1*0.5%,"")))

I am not clear about your final statement €œbonus $2000 if total sales 10000€�.

--
Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"kiki" wrote:

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

how do I enter this in excel sumif
 

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%
--
Regards
Roger Govier

kiki wrote:
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