Posted to microsoft.public.excel.programming

Karen53

external usenet poster

Posts: 333

Complex IF OR AND Statement

Hi,

I have a cell that is set to watch two other cells and flag a warning if
they do not match. I have it so the flag will come up if they do not match
but it doesn't clear when they do match. Can anyone help?

=IF(OR(OR(AND($B$26="Yes",LEFT($E$1,6)<"Anchor"), AND($B$26="Yes",LEFT($E$1,5)<"Major")),AND($B$26= "No",LEFT($E$1,6)="Anchor"),AND($B$26="No",(LEFT($ E$1,5)="Major"))),"Major Indicators do not match","")
--
Thanks for your help.
Karen53

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
complex if statement	kdel1201	Excel Worksheet Functions	1	November 8th 09 03:02 PM
Complex IF Statement	Jonni	Excel Discussion (Misc queries)	7	June 26th 09 04:09 PM
Complex IF STATEMENT	CR3	Excel Discussion (Misc queries)	3	December 6th 07 12:32 PM
complex IF statement	cathy	Excel Programming	5	September 21st 07 08:34 PM
Help with complex If statement	GHawkins[_2_]	Excel Worksheet Functions	2	September 6th 07 10:16 PM

All times are GMT +1. The time now is 06:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us