IF Function - formula creation

[Guest]

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?

 

[Niek Otten]

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,"")

 

[Gary Keramidas]

try this

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

 

[Guest]

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.