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
|