IF, And Formula

[Anto111]

Hi guys,

I am attempting a formula to pick up a specific cell value providing that
two criteria are filled as specified in other cells.

My current formula is: =IF(Y47="Team", AND(I43="1st Half",
AD47,IF(Y47="Team",AND(I43="2nd Half",AD48))))

Currently if both criteria are met the formula cell is simply returning
"True", and if the criteria is not met then it is returning "False". Have you
any suggestions as to what I need to add to the formula so that it may return
the value in the target cell?

All Help would be very warmly appreciated.

Many thanks in advance,

Ant

 

[Bob Greenblatt]

Hi guys,

I am attempting a formula to pick up a specific cell value providing that
two criteria are filled as specified in other cells.

My current formula is: =IF(Y47="Team", AND(I43="1st Half",
AD47,IF(Y47="Team",AND(I43="2nd Half",AD48))))

Currently if both criteria are met the formula cell is simply returning
"True", and if the criteria is not met then it is returning "False". Have you
any suggestions as to what I need to add to the formula so that it may return
the value in the target cell?

All Help would be very warmly appreciated.

Many thanks in advance,

Ant

You are misinterpreting the way Excel IF formulas work. The first section is
an expression that evaluates to true or false, the second section is the
expression if True, and the third, if FALSE. And, you may nest these
conditions. So, you IF statement ought to look like:
=if(y47="Team",if(i43="1st half",ad47,if(i43="2nd Half",ad48,"different
half")),"not team")

Or, alternatively:
=if(and(y47="Team",i43="1st half"),ad47,if(and(y47="team",i43="2nd
half"),ad48,"something else"))