Using More than 7 if functions in a formula

[jack_sxh]

Help--I am totally new at this feature of spreadsheets.

I am trying to create a formula that needs more than 7 if functions i
a formula.

I want to be able to type in a weight and it will automatically choos
the value that should be assigned to it. The weights range from 110 t
260. I have found out that you can only use 7 IF functions in
formula. I have put in the following formula up to the 7th I
function, but don't know where to go from here:

If(B4=110,.656,if(b4=111,.659,if(b4=112,.661,if(b4=113,.665,if(b4=114,.669,if(b4=115,.673,if(b4=116,.678

I have read something about VLookups, but do not understand how to d
this? Do I need to create something else? I need some detailed hel
on how to handle this problem. Can you help?

Miss

 

[A.W.J. Ales]

Missy,

Try
=CHOOSE(B4-109,656,659,661,665,669,673,678)

IF can't be "nested" more than 7 levels deep.
--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Norman Harker]

Hi Jack!

In H1:I7 I have:
110 0.656
111 0.659
112 0.661
113 0.665
114 0.669
115 0.673
116 0.678


That gives me a formula I can use:

=VLOOKUP(B4,$H$1:$I$7,2,FALSE)

B4 is the cell being looked up
$H$1:$I$7 is the location of the table to look it up in. I've
absolutely referenced so that you can copy down the formula.
2 is the column number that you want the value of
FALSE indicates that I want an exact match of B4 with an entry in
column 1 of the table. That may or may not be the case but if you can
change to TRUE or omit the argument if it isn't.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.