About Us

"Bill Kuunders" wrote:

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What's wrong with this vb?	DaveMoore	Excel Worksheet Functions	2	February 24th 05 01:29 PM
Subtotal of Subtotal displays Grand Total in wrong row	Thomas Born	Excel Worksheet Functions	5	January 6th 05 01:46 PM
multi-level subtotals are in the wrong position	Worksheet Guru need	Excel Worksheet Functions	1	December 6th 04 05:22 PM
Logic statement returns wrong answer.	Tony	Excel Worksheet Functions	2	December 2nd 04 05:07 AM
IF function displays wrong amount	JAnderson	Excel Worksheet Functions	4	November 6th 04 06:41 PM

Menu

About Us