Quote:
Originally Posted by Stephen Reed
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.
|
Help from
Brazil
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(F
8="N",G
8="Y",H
8="Y",I
8="Y"),"Y
es"
,"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.