IF, AND Formula

A

Anto111

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
 
M

Mike H

Maybe

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula IF 1
Hlookup extension 1
Multiple "IF" statements in a formula 1
How do I write this formula 1
Blanks ("") by Formula 2
Excel formula, sum the value cell and if empty cell left blank 0
Second to last entry 4
if(isna(match formula 8

Top