# Solved Excel IF statment - Need help Microsoft Excel for mac 2011 - macintosh
August 30, 2011 at 17:24:18
Specs: N/A
 I can't figure out how to combine these to formulas. I know they are not correct, just can't figure it out. I know I need to remove the IF(F3>=E10,"0" and IF(F3<=D11,"0". But this is how I can get the two to work separately.=IF(F3>=E10,"0",IF(F3<=C11,F3*C9,IF(F3>=D10,C13+((F3-D10)*D9))))=IF(F3<=D11,"0",IF(F3<=E11,C13+D13+((F3-E10)*E9),IF(F3>=F10,F13+((F3-F10)*F9))))What I'm trying to do is:See dataif F3 is between 0-30,000, multiply by \$1. If F3 is between 30,001-75,000, multiply ((F3-30,001)*.8)+\$30,000. If F3 is between 75,001-120,000, multiply ((F3-75,001)*.5)+\$30,000+\$35,999.If F3 is greater the 120,001 the multiply ((F3-120,001)*.4)+30,000+35,999,+\$22,499.I'm trying to compound the \$ as it achieves the different levels. So, if we hit 120,000 units it will add \$30,000+35,999+22,499=88,498. If we hit 80,000 units it should be \$30,000+35,999+((80,000units-75,001units)*.5)=\$68,498.F3 - (X) Total unitsC9 - \$1C10 - 0 C11 - 30000 D9 - \$.8D10 - 30001 D11 - 75000E9 - \$.5E10 - 75001 E11 - 120000 F9 - \$.4F10 - 120001Anyone!!! See More: Excel IF statment - Need help

#1 August 30, 2011 at 19:20:16 