Logical if

Hi all,
Am a newbee in Excel.
My requirement is ....
I have a list of customers with their payments status such as "Quarterly (Q), Half Yearly (H) and Yearly(Y)

Now what i am looking is a formula which checks basing on the column where Q, H and Y are existing and in the next 4 columns (column headings are Q1,Q2,Q3 and Q4) it should put ...........

1. all "YES" in all 4 columns if the cell says Q,
2. only first 2 columns it should put "Yes" and rest 2 columns "No", if the cell say H and
3. only first column it should put "Yes" and rest 3 columns "No", if the cell says Y

Hope i am clearing in asking the question.

Thanks in advance.

tRY:

=IF($H2="Q","Yes",IF(AND($H2="H",OR(I$1={"Q1","Q2"})),"Yes",IF(AND($H2="Y",I$1="Q1"),"Yes","No")))

Where your Q,H,Y are placed in A2, down and your Q1 - Q4 headers begin in B1

I think this is what you need:

Hi,

presuming your Q H Y data is in column A,

Q1 =IF($A2="Q","YES",IF($A2="H","YES",IF($A2="Y","YES","")))
Q2 =IF($A2="Q","YES",IF($A2="H","YES",IF($A2="Y","NO","")))
Q3 =IF($A2="Q","YES",IF($A2="H","NO",IF($A2="Y","NO","")))
Q4 =IF($A2="Q","YES",IF($A2="H","NO",IF($A2="Y","NO","")))

Hi,

If B1:E1 =Q1,Q2,Q3,Q4

=IF($A2="Q","Yes",IF(AND(OR(B$1="Q1",B$1="Q2"),$A2="H"),"Yes",IF(AND($A2="Y",B$1="Q1"),"Yes","No"))) drag across and down

Originally Posted by oldchippy

Hi,

If B1:E1 =Q1,Q2,Q3,Q4

=IF($A2="Q","Yes",IF(AND(OR(B$1="Q1",B$1="Q2"),$A2="H"),"Yes",IF(AND($A2="Y",B$1="Q1"),"Yes","No"))) drag across and down

Looks familiar...

Sorry, I was working on it, got dragged away, so by the time I got back I thought I'd post it any way just in case

Hi Excel999,

As this is another question can you please post again but start a new thread and also can you attach your workbook with an explanation of exactly what you require and the expected result and I'm sure one of us will be able to help you further.

BTW Merry Christmas