Thread: IF FORMULA
View Single Post
  #1   Report Post  
 
Posts: n/a
Default IF FORMULA

Thanks so much for helping me earlier, 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) 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