Here is the corrected formula I used: =IF(C4<=B8,C4*C8),IF(C4>=B10,C4*C11),IF(AND(C4<=B9,C4>B8),C4*C9),IF(AND(C4<=B10,C4>B9),C4*C10)
I am trying to link an associated percentage (cell c8 thru c11) with a base amount (c4) based on where it falls relative a certain size.
So, if the current base amount (c4) is less than or equal to 100 (b8) the fee is c4 x c8 (the fee .25)
if the base amount is equal to or greater than the last bracket amount (b10) then it is the base amount times c11 (.10)
Then there are two inside amounts
if the base amount is less than or equal to 200 (b9) and greater than 100 (b8) then c4 times c9 (.2)
if the base amount is less than or equal to 500 (b10) and greater than 100 (b9) then c4 times c10 (.15)
Hope the above makes sense...
Truly appreciate your help.