IF AND Formulas with two sets of functions

**Zipmeister** · 07-26-2012, 06:10 AM

Here is basically what I am attempting to achieve but I am struggling to get it to work.

I will keep it simple as I have a lot of data!

In my table i have columns such as Horse Age, Course, Course Win and so on and what I want it this....

=IF(AND([Horse Age]=[@[Horse Age]],[Course]=[@Course],[Course Win]=[@[Course Win]]) Equal or Greater than 10

=IF(AND([Horse Age]=[@[Horse Age]],[Course]=[@Course],[Course Win]=[@[Course Win]],[Result]="Won") Equals 0

What I need to do is combine these two formulas so if they both achieve there targets then the cells produces an "F" or if not then a "P". I also want to use more than one formula in the cell, so multiply formula's which will produce an "F" at the first target reached and a "P" if none of those reached the target. I am pretty sure I will be able to sort out the multiply formula's once I know how to get the first one working.

Thank You in advanced for any help.

**dilipandey** · 07-26-2012, 06:16 AM

Hi Zipmeister,

=IF(AND([Horse Age]=[@[Horse Age]],[Course]=[@Course],[Course Win]=[@[Course Win]]) Equal or Greater than 10

What >= 10 ?

Suggest you to upload the sample workbook.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**Zipmeister** · 07-26-2012, 06:28 AM

Yes what I need is the two formula's combined, so if the first formula is ">=10" and the second one is "0" the I would get an output of "F" in the Cell and if not then a "P".

I have uploaded a small example of my workbook. Thank You

Attachment 170481

**Zipmeister** · 07-26-2012, 06:43 AM

Sorry I missed off the three lines which I am trying to condense!

Columns BE, BF & BG are the three which I want to get all into one cell if this is possible. Thank You

Example.xlsm

I believe it should be along these lines but I cannot get it to work!...
=IF(AND(COUNTIFS([Horse Age],[@[Horse Age]],[Course Win],[@[Course Win]])>=10,COUNTIFS([Horse Age],[@[Horse Age]],[Course Win],[@[Course Win]],[Result],"Won")=0,"F","P"))

**Zipmeister** · 07-26-2012, 07:21 AM

Right after lots of messing around I have figured it out! Thank You for you help anyway.

=IF(AND(COUNTIFS([Horse Age],[@[Horse Age]],[Course Win],[@[Course Win]])>=10,COUNTIFS([Horse Age],[@[Horse Age]],[Course Win],[@[Course Win]],[Result],"Won")=0),"F","P")