Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need a fuction that can do this (or can it be done) | Excel Worksheet Functions | |||
For Each Fuction??? | Excel Discussion (Misc queries) | |||
Insert Fuction | Excel Worksheet Functions | |||
IF fuction and format ... | Excel Worksheet Functions | |||
Page Number Fuction | Excel Discussion (Misc queries) |