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