=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 |
