Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
IF FORMULA
I have tried this formula several ways and nothing works, please help
=IF(B6<=15.4,"/56)","IF(B6=15.5("100"-B5)/84.5*B5/56") So basically if cell B6 is less than or equal to 15.4 only divide by 56. If cell B6 is greater than or equal to 15.5 run the following formula (100-B5)/84.5*B5/56") |
#2
|
|||
|
|||
=IF(B6<=15.4,B6/56,(100-B5)/84.5*B5/56)
-- HTH Bob Phillips wrote in message ups.com... I have tried this formula several ways and nothing works, please help =IF(B6<=15.4,"/56)","IF(B6=15.5("100"-B5)/84.5*B5/56") So basically if cell B6 is less than or equal to 15.4 only divide by 56. If cell B6 is greater than or equal to 15.5 run the following formula (100-B5)/84.5*B5/56") |
#3
|
|||
|
|||
Really appreciate your help and so fast too! I used your formula in
and the table below is a sample of the spread sheet. Everything is working except when the MOIST. column which is below 15.4 - it is 14.8 the DRY BU should be 974.29 just like the WET BU. Hope that made sense. NET WT MOIST. WET BU DRY BU 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 | |||
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) |