Hi Guys,

I am trying to create a formula to return a cell value, providing that 2
other specified criteria are satisfied.

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

At present however, if the criteria is satisfied the formula cell is simply
returning "True" and if unsatisfied "False". Could anybody please suggest how
I can alter the formula to return the actual value?

Any help would be very warmly appreciated.

Many thanks in advance,

kind regards,

Ant

Maybe

=IF(AND(Y47="Team",I43="1st Half"),AD47,IF(AND(Y47="Team",I43="2nd
Half"),AD48))

Mike

"Anto111" wrote:

Hi Guys,

I am trying to create a formula to return a cell value, providing that 2
other specified criteria are satisfied.

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

At present however, if the criteria is satisfied the formula cell is simply
returning "True" and if unsatisfied "False". Could anybody please suggest how
I can alter the formula to return the actual value?

Any help would be very warmly appreciated.

Many thanks in advance,

kind regards,

Ant