If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula problem with Excel 2010
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. |
#2
|
|||
|
|||
Formula problem with Excel 2010
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. |
#3
|
|||
|
|||
Formula problem with Excel 2010
Jacob, thanks for replay. I cannot enter that formula too.
Let me underline where I enter the formula again. I select a range of cells on a row. (=$A$3:$I$3) Then I hit conditional formatting and add a new rule. I select Use a formula to determine which cells to format. then I cannot enter anything like =IF(AND(H3=1,I3=1),"True","False") this. Somehow excel says formula contain errors. If I edit my formula like ="IF(AND(H3=1,I3=1),"True","False")" then Excel accepts it but nothing changes. note that if I enter =H3=1 then it checks for that cell for that value and if its ture some coloring happens(as i arranged). cant enter abit more compex formulas "Jacob Skaria" wrote: 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. |
#4
|
|||
|
|||
Formula problem with Excel 2010
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. |
#5
|
|||
|
|||
Formula problem with Excel 2010
Oops.. I missed that it was conditional formatting..
--Select the range A3:I3 --Enter the below formula to format the selected range if H3 and I3 = 1 =AND($H3=1,$I3=1) -- Jacob "mns" wrote: Jacob, thanks for replay. I cannot enter that formula too. Let me underline where I enter the formula again. I select a range of cells on a row. (=$A$3:$I$3) Then I hit conditional formatting and add a new rule. I select Use a formula to determine which cells to format. then I cannot enter anything like =IF(AND(H3=1,I3=1),"True","False") this. Somehow excel says formula contain errors. If I edit my formula like ="IF(AND(H3=1,I3=1),"True","False")" then Excel accepts it but nothing changes. note that if I enter =H3=1 then it checks for that cell for that value and if its ture some coloring happens(as i arranged). cant enter abit more compex formulas "Jacob Skaria" wrote: 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. |
#6
|
|||
|
|||
Formula problem with Excel 2010
I just tried this in 2010 and it worked fine. I have seen this before, in
some previous Excel version, but I cannot recall the circumstances. If I remember, I will post back. -- HTH Bob "mns" wrote in message ... 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. |
#7
|
|||
|
|||
Formula problem with Excel 2010
yes thank you guys but the problem is i cannot use
=AND($H3=1,$I3=1). Thats what is the problem excel says there is an error. I am using office 2010 i can enter formula if i type like ="AND($H3=1,$I3=1)" this. This is my problem "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. . |
#8
|
|||
|
|||
Formula problem with Excel 2010
See my other response.
-- HTH Bob "mns" wrote in message ... yes thank you guys but the problem is i cannot use =AND($H3=1,$I3=1). Thats what is the problem excel says there is an error. I am using office 2010 i can enter formula if i type like ="AND($H3=1,$I3=1)" this. This is my problem "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. . |
#9
|
|||
|
|||
Formula problem with Excel 2010
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. . |
#10
|
|||
|
|||
Formula problem with Excel 2010
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. . |
|
Thread Tools | |
Display Modes | |
|
|