IF FUCTION
 

Please help. I used the following formula
=IF(B6<=15.4,B6/56,(100-B5)/84.5*B5/56) in the DRY BU column in the
table below. The formula in WETBU just divides the NET column by 56.
The formula is working when the WETBU is 15.5 or above but when the
(MOIST column B6) is (below 15.4 - it is 14.8)it's incorrect-.26 The
WETBU and the DRY BU 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

so

should it be A6/56???

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

in stead of B6/56
=IF(B6<=15.4,B6/56,(100-B5)/84.5*B5/56)


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=469902