My formula is for total annual sales, where cell B3 is 2510000 and the formula is =IF(B3>2500000,((B3-500000)*0.11)+(500000*0.1)+(500000*0.09)+(300000*0.08)+(300000*0.07)+(600000*0.05)+(300000*0.04)),IF(B3>2000000,((B3-2000000)*0.1)+(500000*0.09)+(300000*0.08)+(300000*0.07)+(600000*0.05)+(300000*0.04)),IF(B3>1500000,((B3-1500000)*0.09)+(300000*0.08)+(300000*0.07)+(600000*0.05)+(300000*0.04)),IF(B3>1200000,((B3-1200000)*0.08)+(300000*0.07)+(600000*0.05)+(300000*0.04)),IF(B3>900000,((B3-900000)*0.07)+(600000*0.05)+(300000*0.04)),IF(B3>600000,((B3-600000)*0.05)+(300000*0.04)). I have minimized my parentheses to get rid of the formula errors, but now #VALUE!
2007-02-01
11:04:35
·
5 answers
·
asked by
Commissioner
1