Thanks everyone. It did work here, I ended up having a space in the
formula that was goofing it up.
Thanks again!!
On 10/19/2010 11:13 AM, JimHays wrote:
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:
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 10/19/2010 11:01 AM >>>
I am trying to write a formula that will look at a
=IF(AND(D3>64,D3<70),"Probation", "Ok")
seems to work here
>>> William Upp 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
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 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 r
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 i
