I am a bit of novice, so any help is appreciated. I have a IF(AND statement that tests several criteria. I have a bunch of these statements that work fine, but thislast one I can not get to work. I have a cell called AP1P2 that contains a > depending on what I enter. I am trying to pull the sign into a equation. The values I want to compare is in A1 with value 1, A2 with value of 2, and A3 with value of for example. So here is what I have:
=IF(AND(A1&AP1P2&"=0", A2&AP1P2&"=0",A3&AP3P4&"=0"), 1, 0)
I am trying to get it to build the statement and evaluate it. Say I enter a > in the cell named AP1P2 it would perform the folowing:
=IF(AND(1>=0, 2>=0, 3>=0), 1, 0)
=IF(AND(True, True, True), 1, 0) So it returns a 1.
When I step through the formula it tells me the following:
=IF(AND("1>=0", "2>=0", "3>=0"), 1, 0) then it says
=IF(AND(#value!), 1, 0) and will not evaluate the expression.
Can anyone help a novice out? Thanks, Brian
=IF(AND(A1&AP1P2&"=0", A2&AP1P2&"=0",A3&AP3P4&"=0"), 1, 0)
I am trying to get it to build the statement and evaluate it. Say I enter a > in the cell named AP1P2 it would perform the folowing:
=IF(AND(1>=0, 2>=0, 3>=0), 1, 0)
=IF(AND(True, True, True), 1, 0) So it returns a 1.
When I step through the formula it tells me the following:
=IF(AND("1>=0", "2>=0", "3>=0"), 1, 0) then it says
=IF(AND(#value!), 1, 0) and will not evaluate the expression.
Can anyone help a novice out? Thanks, Brian