Hi all,
I am attempting to enter a formula into excel, such that if the annual volume falls in a certain range, then the fee per pack updates accordingly (i.e., the higher the volume, the lower the fee per pack). I have attempted to use the 'IF' function,and have posted below the formula that I have entered, but this does not seem to be working. Could anybody advise please? Thank you in advance!
=IF(B4<=899999, [B19], IF(AND(B4>=900000, B4<=999999), [B20], IF(AND(B4>=1000000, B4<=1099999), [B21], IF(AND(B4>=1100000, B4<=1199999), [B22], IF(AND(B4>=1200000, B4<=1299999), [B23], IF(AND(B4>=1300000, B4<=1399999), [B24], IF(AND(B4>=1400000, B4<=1499999), [B25], [B26])))))))
Excel screenshot.png
Bookmarks