IF Statement Using Greater Than and Less Than

  • Thread starter Thread starter James
  • Start date Start date
J

James

I am trying to evaluate a cell to see if:

1. it is over 84 - if true to return a blank space
2. if there is no number in the evaluated cell - return a
blank.
3. if the number is in the range of 1-84 - return the word
complete.

This is what I am trying, but it is not working correctly:

IF(L7>84<1," ","Complete")

For a blank cell, this returns Complete. How can I fix
this?
 
Back
Top