IF FORMULA

  • Thread starter Thread starter macsgirl1105
  • Start date Start date
M

macsgirl1105

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF FUCTION 1
IF FUNCTION 1
IF FORMULA 1
IF function 1
How do I calculate within a range? 5
generate automatically sum 6
how can i calculate a three variable if statement in excel 2
if true, if not nested if funcion 2

Back
Top