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")

=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")

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