Cross referance chart formula help

[HVACTESTING]

Hello Experts,

I have been working on theis cross referance formula for a while. I now need some help. I may be close but not close enough. This chart is used for a HVAC application. 51 is wet bulb temp, 71 is dry bulb temp, the cross referance would be 21.3.

<TABLE style="WIDTH: 147pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=196><COLGROUP><COL style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 1462" width=40><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" width=47><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2267" width=62><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" width=47><TBODY><TR style="HEIGHT: 18.75pt" height=25><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 30pt; HEIGHT: 18.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl70 height=25 width=40></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 35pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 width=47>50</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 47pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 width=62>51</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 35pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 width=47>52</TD></TR><TR style="HEIGHT: 18pt; mso-height-source: userset" height=24><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 18pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl71 height=24>70</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67>20.9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>20.7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>20.6</TD></TR><TR style="HEIGHT: 18pt" height=24><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 18pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl72 height=24>71</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>21.4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69>21.3</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69>21.1</TD></TR><TR style="HEIGHT: 18pt" height=24><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 18pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl72 height=24>72</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>21.9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69>21.8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69>21.7</TD></TR><TR style="HEIGHT: 18pt" height=24><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 18pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl72 height=24>73</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>22.5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69>22.4</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69>22.2</TD></TR><TR style="HEIGHT: 18pt" height=24><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 18pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl72 height=24>74</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66>23.0</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69>22.9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69>22.8</TD></TR></TBODY></TABLE>=INDEX(E29,C8:C22,D7:AD22,D8:AD22)*(match(E31,D7:AD7,D8:AD22,FALSE))

E29 is 71 , E31 is 51
Any suggestions?

Thanks for your help Tim

 

[AlphaFrog]

Try something like this...

<table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:48px;" /><col style="width:48px;" /><col style="width:48px;" /><col style="width:48px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:23px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="font-family:Verdana; "> </td><td style="text-align:center; ">50</td><td style="text-align:center; ">51</td><td style="text-align:center; ">52</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:center; ">70</td><td style="text-align:center; ">20.9</td><td style="text-align:center; ">20.7</td><td style="text-align:center; ">20.6</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:center; ">71</td><td style="text-align:center; ">21.4</td><td style="text-align:center; ">21.3</td><td style="text-align:center; ">21.1</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:center; ">72</td><td style="text-align:center; ">21.9</td><td style="text-align:center; ">21.8</td><td style="text-align:center; ">21.7</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:center; ">73</td><td style="text-align:center; ">22.5</td><td style="text-align:center; ">22.4</td><td style="text-align:center; ">22.2</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:center; ">74</td><td style="text-align:center; ">23</td><td style="text-align:center; ">22.9</td><td style="text-align:center; ">22.8</td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:22px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">21.3</td><td > </td><td > </td><td > </td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >A8</td><td >=INDEX(A1:D6,MATCH<span style=' color:008000; '>(E29,A1:A6,0)</span>,MATCH<span style=' color:008000; '>(E31,A1:D1,0)</span>)</td></tr></table></td></tr></table>


E29 is 71
E31 is 51

 

[HVACTESTING]

Thank you for the help.

Your a real time saver for the visually impared.

 

[HVACTESTING]

PASS FAIL formula for a spread sheet

Hello Alpha Frog,

I guess my problem is AADD(adult attention deffiecent disorder)
Here is ny scenario. I have an answer of -/+ 4 This would equal PASS.
The problem I have is anything above or below -/4 would equal FAIL.

<TABLE style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; MARGIN: auto auto auto 3.15pt; BORDER-COLLAPSE: collapse; BORDER-TOP: medium none; BORDER-RIGHT: medium none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: .5pt solid windowtext" class=MsoNormalTable border=1 cellSpacing=0 cellPadding=0><TBODY><TR style="HEIGHT: 10.5pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 186.75pt; PADDING-RIGHT: 5.4pt; HEIGHT: 10.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid windowtext .5pt" vAlign=top width=249>A<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 185.25pt; PADDING-RIGHT: 5.4pt; HEIGHT: 10.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt" vAlign=top width=247>B<o></o>

</TD></TR></TBODY></TABLE><TABLE style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; MARGIN: auto auto auto -14.25pt; BORDER-COLLAPSE: collapse; BORDER-TOP: medium none; BORDER-RIGHT: medium none; mso-border-alt: solid black .5pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-border-themecolor: text1; mso-yfti-tbllook: 1184" class=MsoTableGrid border=1 cellSpacing=0 cellPadding=0><TBODY><TR style="HEIGHT: 14.85pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 14.25pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.85pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid windowtext .5pt; mso-border-right-themecolor: text1; mso-border-right-alt: solid black .5pt" vAlign=top width=19><o></o>

​

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 372.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.85pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-left-themecolor: text1" vAlign=top width=497 colSpan=2>

Min Air flow<o></o>​

</TD></TR><TR style="HEIGHT: 14.85pt; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 14.25pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.85pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid windowtext .5pt; mso-border-right-themecolor: text1; mso-border-right-alt: solid black .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width=19>1<o></o>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 186.2pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.85pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-right-themecolor: text1; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-top-themecolor: text1" vAlign=top width=248>Return AIR Dry bulb<o></o>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 186.3pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.85pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-right-themecolor: text1; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-top-themecolor: text1" vAlign=top width=248>76<o></o>

</TD></TR><TR style="HEIGHT: 13.95pt; mso-yfti-irow: 2"><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 14.25pt; PADDING-RIGHT: 5.4pt; HEIGHT: 13.95pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid windowtext .5pt; mso-border-right-themecolor: text1; mso-border-right-alt: solid black .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width=19>2<o></o>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 186.2pt; PADDING-RIGHT: 5.4pt; HEIGHT: 13.95pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-right-themecolor: text1; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-top-themecolor: text1" vAlign=top width=248>Supply air Dry bulb<o></o>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 186.3pt; PADDING-RIGHT: 5.4pt; HEIGHT: 13.95pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-right-themecolor: text1; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-top-themecolor: text1" vAlign=top width=248>56<o></o>

</TD></TR><TR style="HEIGHT: 14.85pt; mso-yfti-irow: 3"><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 14.25pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.85pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid windowtext .5pt; mso-border-right-themecolor: text1; mso-border-right-alt: solid black .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width=19>3<o></o>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 186.2pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.85pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-right-themecolor: text1; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-top-themecolor: text1" vAlign=top width=248>Return Wet Bulb<o></o>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 186.3pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.85pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-right-themecolor: text1; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-top-themecolor: text1" vAlign=top width=248>52<o></o>

</TD></TR><TR style="HEIGHT: 14.85pt; mso-yfti-irow: 4"><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 14.25pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.85pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid windowtext .5pt; mso-border-right-themecolor: text1; mso-border-right-alt: solid black .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width=19>4<o></o>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 186.2pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.85pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-right-themecolor: text1; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-top-themecolor: text1" vAlign=top width=248>R/A Wet Bulb target<o></o>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 186.3pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.85pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-right-themecolor: text1; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-top-themecolor: text1" vAlign=top width=248>23.9<o></o>

</TD></TR><TR style="HEIGHT: 14.85pt; mso-yfti-irow: 5"><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 14.25pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.85pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid windowtext .5pt; mso-border-right-themecolor: text1; mso-border-right-alt: solid black .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width=19>5<o></o>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 186.2pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.85pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-right-themecolor: text1; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-top-themecolor: text1" vAlign=top width=248>Delta T Dry Bulb - / + 4 <o></o>

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 186.3pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.85pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-right-themecolor: text1; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-top-themecolor: text1" vAlign=top width=248>-3.9<o></o>

​

</TD></TR><TR style="HEIGHT: 14.85pt; mso-yfti-irow: 6; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 14.25pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.85pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid windowtext .5pt; mso-border-right-themecolor: text1; mso-border-right-alt: solid black .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=top width=19>

6<o></o>

​

</TD><TD style="BORDER-BOTTOM: black 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 372.5pt; PADDING-RIGHT: 5.4pt; HEIGHT: 14.85pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: black 1pt solid; PADDING-TOP: 0in; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-right-themecolor: text1; mso-border-left-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-top-themecolor: text1" vAlign=top width=497 colSpan=2>

Pass<o></o>​

</TD></TR></TBODY></TABLE>
=IF(B5>4,"pass","fail")

Any suggestions? Thanks for your time!
Tim

 

[AlphaFrog]

Use the ABS function...
=IF(ABS(B5)<=4,"Pass","Fail")