Posted to microsoft.public.excel.worksheet.functions

AND & OR in a IF loop AND & OR in a IF loop is offline

external usenet poster

Posts: 1

"AND" & "OR" in a IF loop

how do I combine AND and OR in a nested IF statement.
eg: IF((AND(ab=5,ac=1)or(ac=2),"correct",if(........)) )
pls 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
Loop time seems dependent on unrelated workbook - Why?	Richard	Excel Worksheet Functions	2	March 30th 06 11:59 PM
Combining "AND" with "OR" Statements	keen learner	Excel Worksheet Functions	4	February 2nd 06 06:35 AM
Loop gone crazy	Dave Peterson	Excel Discussion (Misc queries)	4	December 16th 05 03:38 PM
Do Loop	Noemi	Excel Discussion (Misc queries)	0	December 8th 05 10:43 PM
hysteresis loop	olivekim	Charts and Charting in Excel	1	October 28th 05 04:22 AM

All times are GMT +1. The time now is 11:49 PM.

About Us

"It's about Microsoft Excel"