LOOKUP/IF Formula Help!!

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?
 
T

T. Valko

B1 is for values 80-90, B2 is for values > 90.01 - 100, B3
is for values 100.01 - 110, etc.

B1, B2, B3 etc doesn't match what you have in your formulas. What does C8,
E8, G8 and I8 have to do with it?

You have replies to your post from last night. Did they not work?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top