Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif? array enter? | Excel Discussion (Misc queries) | |||
SUMIF - how to enter a second criteria | Excel Discussion (Misc queries) | |||
Macro to select cells in column enter data then press enter | New Users to Excel | |||
enter doesn't work with sumif | Excel Worksheet Functions | |||
Multiple Criteria Sumif/Sum..tried & failed Ctrl+Shift+Enter, | Excel Discussion (Misc queries) |