Thread: IF FORMULA
View Single Post
  #1   Report Post  
 
Posts: n/a
Default 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")