Logical if

[Excel999]

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.