Need help with a formula

S

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 nee
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 formul
to say they don't qualify i get a #value error.

Any help on this matter is will be greatly appreciated.

Thank you

Stephen
 
C

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
 
M

Mazzaropi

Stephen said:
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 nee
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 formul
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 yo
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 abou
them. Then be so clear as possible on your explanation.

Have a nice Day
 
S

Stephen Reed

Claus,

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

Again Thank You.

Stephen.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top