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?