Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
|
|||
|
|||
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.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
#4
|
|||
|
|||
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:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula autofill to cells below – formula arguments are cell areas in different columns | Excel Discussion (Misc queries) | |||
Build formula using field values as text in the formula referencing another workbook | Links and Linking in Excel | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |