2 sets of =if strings in excel 2007
 

This question references an earlier thread of mine.
If the value of H2=184,then the first =if statement should be used to
display a value in B30.
If the value of H2=189, then the second =if statement should be used to
display a value in B30.
The formula is entered in B30.
=IF(B29=22,"-12.2",IF(B29=21,"-11.6",IF(B29=20,"-11.0",IF(B29=19,"-10.5",
etc...
=IF(B29=22,"-12.5",IF(B29=21,"-11.9",IF(B29=20,"-11.4",IF(B29=19,"-10.8",
etc...
What could be a quick/easy way to express this?

2 sets of =if strings in excel 2007
 

You should create a 3 column table like this:

...........A..........B..........C
1...................184.......189
2.......22......-12.2.....-12.5
3.......21......-11.6.....-11.9
4.......20......-11.0.....-11.4
5.......19......-10.5.....-10.8

Then your formula in B30 is:

=VLOOKUP(B29,A1:C5,MATCH(H2,A1:C1,0),0)


--
Biff
Microsoft Excel MVP


"v1rt8" wrote in message
...
This question references an earlier thread of mine.
If the value of H2=184,then the first =if statement should be used to
display a value in B30.
If the value of H2=189, then the second =if statement should be used to
display a value in B30.
The formula is entered in B30.
=IF(B29=22,"-12.2",IF(B29=21,"-11.6",IF(B29=20,"-11.0",IF(B29=19,"-10.5",
etc...
=IF(B29=22,"-12.5",IF(B29=21,"-11.9",IF(B29=20,"-11.4",IF(B29=19,"-10.8",
etc...
What could be a quick/easy way to express this?