That formula works as you think it should in my copy of Excel 2007. Perhaps your worksheet isn't recalculating?
On Tue, Oct 19, 2010 at 11:01 AM, William Upp <w...@bluffs-school.com>wrote: > 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 | > -- -- Ben Story CCSP, CCNA, CCNA Wireless, CCDA ben.st...@gmail.com "You cannot escape the responsibility of tomorrow by evading it today. -- Abraham Lincoln
| Subscription info at http://www.tech-geeks.org |
