IF Function - formula creation
 

I am trying to do a formula that will pull a value from a cell if two
conditions are present. I have created IF(AND(D9='X'),(F9='R'),AB9)
I am getting TRUE text....I want the value in AB9 ( 36) to appear in cell
Any suggestions?

IF Function - formula creation
 

You need to specify what the cell should be if the conditions are not met.
Also the brackets are in the wrong place and the single quotes should be
double ones.
If it has to blank, use

IF(AND(D9="X",F9="R"),AB9,"")

--
Kind regards,

Niek Otten

"emily's excel" <emily's wrote in message
...
I am trying to do a formula that will pull a value from a cell if two
conditions are present. I have created IF(AND(D9='X'),(F9='R'),AB9)
I am getting TRUE text....I want the value in AB9 ( 36) to appear in cell
Any suggestions?

IF Function - formula creation
 

try this

=IF(AND(D9="X",F9="R"),AB9,"")

--


Gary


"emily's excel" <emily's wrote in message
...
I am trying to do a formula that will pull a value from a cell if two
conditions are present. I have created IF(AND(D9='X'),(F9='R'),AB9)
I am getting TRUE text....I want the value in AB9 ( 36) to appear in cell
Any suggestions?

IF Function - formula creation
 

The "and" function is missing a set of parens. Your formula should read:

IF(AND((D9='X'),(F9='R')),AB9)

I also recommend the you complete the else part of the if statement:

IF(AND((D9='X'),(F9='R')),AB9,0)

--
Please let the group know if this answered your question.


Stewart Rogers
DataSort Software, L.C.


"emily's excel" wrote:

I am trying to do a formula that will pull a value from a cell if two
conditions are present. I have created IF(AND(D9='X'),(F9='R'),AB9)
I am getting TRUE text....I want the value in AB9 ( 36) to appear in cell
Any suggestions?