IF FUNCTION

  • Thread starter Thread starter texasodie
  • Start date Start date
T

texasodie

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF FORMULA 1
IF FUCTION 1
IF FORMULA 2
Problem in If function 7
dynamic range based on criteria, within a dynamic range, passed to a function 5
repeating function q 1
IF Then statement or another function to look for a value 2
Excel Help with Formula 4

Back
Top