Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |