I am trying to write a formula that will look at a cell, and if the
number in that cell is between two other numbers, it will return a
string of text, otherwise it will return another string of text. This
is for an eligibility form I am working on.
Here is what I am trying to do-
If cell D3 is less than 70, but greater than 64, then return
"PROBATION", otherwise return "OK". What I have found online is this
=IF(AND(D3<70,D3>64),"PROBATION", "OK") but so far it does not matter
what number is in cell D3, it returns "OK" as the value.
--
William Upp
Computer and Business Instructor
Technology Coordinator
Bluffs Schools
Bluffs, IL
| Subscription info at http://www.tech-geeks.org |
