A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Formula problem with Excel 2010



 
 
Thread Tools Display Modes
  #1  
Old March 11th, 2010, 07:57 AM posted to microsoft.public.excel.worksheet.functions
mns
external usenet poster
 
Posts: 26
Default 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  
Old March 11th, 2010, 08:07 AM posted to microsoft.public.excel.worksheet.functions
Jacob Skaria
external usenet poster
 
Posts: 5,952
Default 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  
Old March 11th, 2010, 09:36 AM posted to microsoft.public.excel.worksheet.functions
mns
external usenet poster
 
Posts: 26
Default 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  
Old March 11th, 2010, 10:24 AM posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_]
external usenet poster
 
Posts: 489
Default 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  
Old March 11th, 2010, 10:47 AM posted to microsoft.public.excel.worksheet.functions
Jacob Skaria
external usenet poster
 
Posts: 5,952
Default 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  
Old March 11th, 2010, 11:05 AM posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_]
external usenet poster
 
Posts: 489
Default 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  
Old March 11th, 2010, 11:06 AM posted to microsoft.public.excel.worksheet.functions
mns
external usenet poster
 
Posts: 26
Default 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  
Old March 11th, 2010, 11:19 AM posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_]
external usenet poster
 
Posts: 489
Default 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  
Old March 11th, 2010, 12:21 PM posted to microsoft.public.excel.worksheet.functions
Jacob Skaria
external usenet poster
 
Posts: 5,952
Default 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  
Old March 11th, 2010, 12:39 PM posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_]
external usenet poster
 
Posts: 489
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:23 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.