Posted to microsoft.public.excel.worksheet.functions

Colin Hayes Colin Hayes is offline

external usenet poster

Posts: 465

Nested IF AND OR statement

In article , Claus Busch
writes
Hi Colin,

Am Tue, 29 Oct 2013 21:45:59 +0100 schrieb Claus Busch:

=IF((K2="D")+COUNT(FIND({"A","B","C"},E2))=2,"Yes" ,B1)

a bit shorter:
=IF(OR(E2={"A","B","C"})+(K2="D")=2,"Yes",B1)

Regards
Claus B.

Hi Claus

Yes , both perfect. Thanks again for your time and considerable
expertise.

^_^

Best Wishes

Colin

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Nested If statement -- please help :)	HS[_2_]	New Users to Excel	8	May 5th 09 12:18 AM
If statement nested	k11ngy	Excel Discussion (Misc queries)	5	October 13th 08 02:38 PM
IF STATEMENT - NESTED	tojo107	Excel Worksheet Functions	4	April 19th 07 08:14 PM
Nested IF statement	PattiP	Excel Worksheet Functions	4	January 23rd 07 10:56 PM
Nested IF/AND Statement	buffgirl71	Excel Discussion (Misc queries)	1	October 10th 06 01:59 AM

All times are GMT +1. The time now is 01:45 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us