LOOKUP/IF Formula Help!!   

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?

date: Wed, 27 Aug 2008 07:44:00 -0700   author:   DKinNorthCakalacki

Re: LOOKUP/IF Formula Help!!   

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

-- 
Biff
Microsoft Excel MVP


"DKinNorthCakalacki"  wrote in 
message news:F155B8F0-5CB7-4683-B780-2F3A5F8BCF90@microsoft.com...
>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?

date: Wed, 27 Aug 2008 12:13:05 -0400   author:   T. Valko