IF Function - formula creation

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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,"")
 
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.
 
Back
Top