Confusing two logical functions

Hi
I thought I'd ask you guys about a logical formula that is driving my head in.

Basically, I need to write a formula for a work related research grant system.

The rules are:

The number of papers published in a certian timeframe has to be equal to or greater than 4.There are a load of numbers from 0 to 25 i think.

They also have to have a research grant. This will be either yes or no.

I then have to combine these two in a formula, so that a staff member has a research profile rating of ‘A’ if he or she has gained a research grant and published 4 or more papers in the last 10 years. Otherwise, the rating is ‘B’.

I've enclosed the pdf version of the spreadsheet. I have the first part of the formula already:
=IF(B4<4,"no","yes"). In other words, the column b is the number of papers. If 4 or greater, they are active. I know in column D, have a list of research grants "yes" or "no", I want to incorporate that into the same formula, but it won't let me do it!

Any help?

Hi
If you want to return the values A or B then the following formula should work in C4, if the number of papers is in B4 and grant yes or no in D4.

=IF(AND(B4>=4,D4="Yes"),"A","B")

Originally Posted by DBY

Hi
If you want to return the values A or B then the following formula should work in C4, if the number of papers is in B4 and grant yes or no in D4.

=IF(AND(B4>=4,D4="Yes"),"A","B")

Thanks! You are a godsend! did not realsie you can put an AND in there.