Need help with a formula
Hi All,
I want to have two formula in one cell. Let me explain. 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". The formula I am using at the moment is this:- =IF(AND(F2="N",G2="Y",H2="Y",I2="Y"),"Y") This works fine if they qualify, but when I try to add a second formula to say they don't qualify i get a #value error. Any help on this matter is will be greatly appreciated. Thank you Stephen. |
Need help with a formula
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 |
Quote:
Good evening Stephen. Iīm not sure if I understood well exactly what you need. Try to do this: Before.: =IF(AND(F2="N",G2="Y",H2="Y",I2="Y"),"Y") Now....: =IF(AND(F8="N",G8="Y",H8="Y",I8="Y"),"Yes","No") Is this working for you? If not, please, attach your file here and explain exactly what you want. Remember, you must ZIP your file before attach it to the forum Put a clear example about the desirable result. Remember, you are a master of your data but we donīt know nothing about them. Then be so clear as possible on your explanation. Have a nice Day. |
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:
|
All times are GMT +1. The time now is 01:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com