Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |