IF FUNCTION
 

Help please! I used the following formula in the last column DRYBU
=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
when the (MOIST column B6) is 15.5 and above but when it is (below 15.4
- it is 14.8) 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

I am a little confused
from your description I would have assumed your equation should have been

IF(B6<=15.4,A6/56,(100-B6)/84.5*A6/56)

" wrote:

Help please! I used the following formula in the last column DRYBU
=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
when the (MOIST column B6) is 15.5 and above but when it is (below 15.4
- it is 14.8) 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