About Us

Stephen Reed

Claus,

It worked a treat, thank you! That was just what I was looking for. My life has just been made easier.

Again Thank You.

Stephen.

Quote:

Originally Posted by Claus Busch

Hi Stephen,

Am Wed, 10 Apr 2013 16:50:39 +0000 schrieb Stephen Reed:

I have four cells that I need to input a "Y" or "N" into them. They need
to be in order for the person to qualify. so
F8="N",G8="Y",H8="Y",I8="Y" this is what they need to get to qualify.
But if any one of these change they do not qualify e.g-
f8="Y",G8="Y",H8="Y",I8="Y".

try:
=IF(F8&G8&H8&I8="NYYY","Qualified","NotQualified")

Regards
Claus Busch

--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

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
Formula autofill to cells below – formula arguments are cell areas in different columns	[email protected]	Excel Discussion (Misc queries)	1	September 7th 12 09:15 PM
Build formula using field values as text in the formula referencing another workbook	solardirect	Links and Linking in Excel	6	June 4th 12 10:47 PM
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula	PJ[_3_]	Excel Worksheet Functions	2	June 2nd 10 03:45 PM
Formula expected end of statement error, typing formula into cell as part of VBA macro	[email protected]	Excel Programming	1	July 20th 06 07:58 PM
Commenting custom formula fields/formula on formula editor	Muxer	Excel Programming	2	July 24th 03 01:02 AM

Menu

About Us