Quote:
If you go to senario and choose new, then show,
|
I'm sorry I don't understand what you mean
Anyway you have 7 nested IF's which is the maximum allowed , so, no problem there
Also, there is an error in your formula
=IF($D137<=50,($D137*G$1),IF(AND($D137>50,$D137<=1 50),($D137*H$1),IF(AND($D137>=151,$D137<=700),($D1 37*I$1),IF(AND($D137>=701,$D137<=
10000),($D137*J$1),IF(AND($D137>=1001,$D137<=2000),($D1 37*K$1),IF(AND($D137>=2001,$D137<=3000)*($D137*L$1 ),IF(AND($D137>=3001),$D137*M$1)))))))
I think the value in red should be 1000 not 10000 ?