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?

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 excel@discussions.microsoft.com> wrote in message
news:690F187E-655C-456D-AEF0-EEEA26498568@microsoft.com...
>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?

try this

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

--


Gary


"emily's excel" <emily's excel@discussions.microsoft.com> wrote in message
news:690F187E-655C-456D-AEF0-EEEA26498568@microsoft.com...
>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?

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?