Posted to microsoft.public.excel.worksheet.functions

Colin Hayes Colin Hayes is offline

external usenet poster

Posts: 465

Nested IF AND OR statement

Hi All

I need some help with a complicated formula.

I'm trying to say ;

IF E2 contains "A" , OR "B" , OR "C" , AND K2="D" then put "YES". IF not
put B1

Grateful for any help.

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 04:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us