D
DKinNorthCakalacki
I have ben trying to write a formula that will deliver a response based on
where the inout fits within a range.
In short, say Cell A1 = 95. Based on that value, Cell A@ would house a
formula that would then LOOKUP the value of a specified cell base upon its
A1's placement within a range - B1 is for values 80-90, B2 is for values
90.01 - 100, B3 is for values 100.01 - 110, etc.
The formula i tried was
=IF(I10<90%,LOOKUP(C8,C8),IF(I10>90.01%,LOOKUP(E8,E8),IF(I10>105.01%,LOOKUP(G8,G8),IF(I10>115%,LOOKUP(I8,I8))))
but this only delivered C8 or E8. It will nor lookup G8 or I8
I also tried
=IF(I10<90%,LOOKUP(C8,C8),IF(I10>90.01%<105.01%,LOOKUP(E8,E8),IF(I10>105.01%<115%,LOOKUP(G8,G8),IF(I10>115%,LOOKUP(I8,I8)))))
But this ill only give me C8 or I8.
How can I write this formula so that it will work?
where the inout fits within a range.
In short, say Cell A1 = 95. Based on that value, Cell A@ would house a
formula that would then LOOKUP the value of a specified cell base upon its
A1's placement within a range - B1 is for values 80-90, B2 is for values
90.01 - 100, B3 is for values 100.01 - 110, etc.
The formula i tried was
=IF(I10<90%,LOOKUP(C8,C8),IF(I10>90.01%,LOOKUP(E8,E8),IF(I10>105.01%,LOOKUP(G8,G8),IF(I10>115%,LOOKUP(I8,I8))))
but this only delivered C8 or E8. It will nor lookup G8 or I8
I also tried
=IF(I10<90%,LOOKUP(C8,C8),IF(I10>90.01%<105.01%,LOOKUP(E8,E8),IF(I10>105.01%<115%,LOOKUP(G8,G8),IF(I10>115%,LOOKUP(I8,I8)))))
But this ill only give me C8 or I8.
How can I write this formula so that it will work?