IF Statement Using Greater Than and Less Than

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?
 

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

Top