How to use more than 7 IF functions in a formula?

[jack_sxh]

I tried to post a question earlier but it never appeared on the messag
list. Not sure if it went through. So here it is again.

I am trying to set up a formula where when I type in a weight i
another column it will automatically puts in an assigned value for tha
weight. The problem is that the weights range from 110 through 260.
have found that I cannot put in more than 7 IF functions in a formula.
This is my first time trying to do something like this and I am havin
problems. I know there has to be a way to do this.

For example I tried this formula and it worked except I con only put i
7 IF statements:
If(b4=110,.988,ifb4=111,.983,if(br=112,.980 and so on to 7 IF"s

Can anyone explain in detail and laymens terms how I can solve thi
problem. I am definitely a newbie and need help

 

[Greg Koppel]

I have never done it, but I think the answer is to break your formula up to
use in different cells. E.g., in A1 you have the formula =If(B1=true, "yes",
"no") and in B1 you have a nested if that refers to a nested if in C1 and so
on.

HTH, Greg

 

[Karl]

it did and you have two replies!!

 

[kkknie]

You sound like you need a lookup table. I could try to explain here
but it would be easier to search for VLookup or Lookup or Hlookup i
Excel Help.

Basically what a lookup does is let you specify a compare and a retur
range to essentially do a bunch of IFs. Here's a brief example.


Code
-------------------
ColA ColB
110 .988
111 .983
112 .980
113 .977
114 .97
-------------------

Your function would be:

=VLOOKUP(C1,A1:B5,2)

Assuming your entered weight is in cell C1.