Formula problem with Excel 2010
No, I mean to return TRUE or FALSE as your formula did.
--
HTH
Bob
"Jacob Skaria" wrote in message
...
Do you mean to return a text string ??
--
Jacob
"Bob Phillips" wrote:
Even if it is not CF, the IF is redundant.
--
HTH
Bob
"Jacob Skaria" wrote in message
...
I didnt notice that the query is on CF..and thought the OP is trying to
return a text string from the condition....
--
Jacob
"Bob Phillips" wrote:
The IF is totally unnecessary, =AND(H3=1,I3=1) returns TRUE or FALSE
which
is what CF requires.
--
HTH
Bob
"Jacob Skaria" wrote in
message
...
Do you mean
=IF(AND(H3=1,I3=1),"True","False")
--
Jacob
"mns" wrote:
Hi there,
I am trying to enter this formula in conditional formatting window
but my Excel 2010 wont accept it. I get the error "the formula you
entered contains errors".
I tried the formula as
=AND(H3=1,I3=1) and =AND($H$3=1,$I$3=1) doesnt matter.
But when I try it like ="AND(H3=1,I3=1)" Excel accepts this formula
but does nothing:(
My range is =$A$3:$I$3. I cant think of any solutions. help please.
.
.
|