=IF(AND(C2=48,D2=144),"22222",IF(OR(C2="",D2="") ,"","33333"))

Regards
Bill K

"Jeff" wrote in message
...
Thanks ,
This works and yes I want text since it eliminates .000 (I know you can
acheive the same with numbers.)

I have one more question for you: Everthing works great except I want an
empty box (nothing returned) when either C2 or D2 are empty.

Thanks again,
Jeff

" wrote:

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"))))
[....]
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.

=IF(AND(C2 = 48, D2 = 144), "22222", "33333")

By the way, are you sure want __text__ "22222" and "33333"?
Or do you want __numbers___ 22222 and 33333 (without quotes)?