IF FORMULA

[macsgirl1105]

Thanks so much for helping me yesterday, just need a little more
assistance. I used your formula in the DRYBU column
=IF(B6<=15.4,B6/56,(100-B5)/84.5*B5/56) in the table below. The formula
in WETBU just divides the NET column by 56. The formula is working
except when the (MOIST column B6) is (below 15.4 - it is 14.8) with .26
being the result, it should be 974.29 - the WETBU and the DRYBU should
both be the same when the MOIST column is 15.4 or below. Hope that
makes sense.

NET WT MOIST WETBU DRYBU
50540 18 902.50 875.80
52660 15.5 940.36 940.36
54560 14.8 974.29 0.26

 

[JE McGimpsey]

One way:

C6: =IF(B6<=15.4,D6,A6/56)

where B6 contains the Moist reading, D6 has the dry bulb reading and A6
has the Net.