I am doing a price increase calculation comparisons and using scenario manger.
I have written the formula below. This works until it hits a value greater than 800.00. (Attachment has example)
=IF($B882<=50,($B882*H$3),IF(AND($B882>50,$B882<=100),($B882*I$3),IF(AND($B882>=101,$B882<=200),($B882*J$3),IF(AND($B882>=201,$B882<=300),($B882*K$3),IF(AND($B882>=301,$B882<=500),($B882*L$3),IF(AND($B882>=501,$B882<=1000)*($B882*M$3),IF(AND($B882>=1001,$B882<=2000)*($B882*N$3),IF(AND($B882>=2001,$B882<=3000)*($B882*O$3),IF(AND($B882>=3001),$B882*P$3)))))))))
I can not seem to find the problem ..... would appreciate any assistance.
Bookmarks