Here is the formula I came up with but it doesn't do what I want it to.

=IF(C247.999,IF(D2143.999,"22222",IF(C2<47.998,I F(D2<143.998,"33333"))))

If I type 48 or higher in C2 and 144 or higher in D2 it returns "22222"
(this is what i want), but when I type anything lower in either column it
returns "FALSE". I want it to return "33333".

In other words, I want it to return "22222" only when both C2 and D2 are
true, but when either one of them are not true, I want "33333" returned.

Thank you,
Jeff

You have one guess at your post in .misc.

Jeff wrote:

Here is the formula I came up with but it doesn't do what I want it to.

=IF(C247.999,IF(D2143.999,"22222",IF(C2<47.998,I F(D2<143.998,"33333"))))

If I type 48 or higher in C2 and 144 or higher in D2 it returns "22222"
(this is what i want), but when I type anything lower in either column it
returns "FALSE". I want it to return "33333".

In other words, I want it to return "22222" only when both C2 and D2 are
true, but when either one of them are not true, I want "33333" returned.

Thank you,
Jeff

--

Dave Peterson

=IF(AND(C247.999,D2143.999),"22222","33333")

Regards
Bill K



"Jeff" wrote in message
...
Here is the formula I came up with but it doesn't do what I want it to.

=IF(C247.999,IF(D2143.999,"22222",IF(C2<47.998,I F(D2<143.998,"33333"))))

If I type 48 or higher in C2 and 144 or higher in D2 it returns "22222"
(this is what i want), but when I type anything lower in either column it
returns "FALSE". I want it to return "33333".

In other words, I want it to return "22222" only when both C2 and D2 are
true, but when either one of them are not true, I want "33333" returned.

Thank you,
Jeff

=1111*(OR(C2<48,D2<144)+2)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Jeff" wrote in message
...
Here is the formula I came up with but it doesn't do what I want it to.

=IF(C247.999,IF(D2143.999,"22222",IF(C2<47.998,I F(D2<143.998,"33333"))))

If I type 48 or higher in C2 and 144 or higher in D2 it returns "22222"
(this is what i want), but when I type anything lower in either column it
returns "FALSE". I want it to return "33333".

In other words, I want it to return "22222" only when both C2 and D2 are
true, but when either one of them are not true, I want "33333" returned.

Thank you,
Jeff

Thanks,
Jeff