Or you could go the other direction:
=IF(d3>=70,"OK",if(d3<64,"OK","Probation"))
This works here for me as does Bob's.
Bob Munds wrote:
=IF(AND(D3>64,D3<70),"Probation", "Ok")
seems to work here
>>> William Upp <w...@bluffs-school.com> 10/19/2010 11:01 AM >>>
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 <http://www.tech/>-geeks.org |
--- Scanned by M+ Guardian Messaging Firewall --- Clinton Unit School
District --
--- Scanned by M+ Guardian Messaging Firewall --- Clinton Unit School
District --
------------------------------------------------------------------------
| Subscription info at http://www.tech-geeks.org |
| Subscription info at http://www.tech-geeks.org |
