Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,872
Default 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   Report Post  
Senior Member
 
Location: Belo Horizonte, Brazil
Posts: 170
Thumbs up

Quote:
Originally Posted by Stephen Reed View Post
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(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   Report Post  
Junior Member
 
Posts: 2
Default

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 View Post
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula autofill to cells below – formula arguments are cell areas in different columns [email protected] Excel Discussion (Misc queries) 1 September 7th 12 09:15 PM
Build formula using field values as text in the formula referencing another workbook solardirect Links and Linking in Excel 6 June 4th 12 10:47 PM
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula PJ[_3_] Excel Worksheet Functions 2 June 2nd 10 03:45 PM
Formula expected end of statement error, typing formula into cell as part of VBA macro [email protected] Excel Programming 1 July 20th 06 07:58 PM
Commenting custom formula fields/formula on formula editor Muxer Excel Programming 2 July 24th 03 01:02 AM


All times are GMT +1. The time now is 06:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"