Can the AND operator be of use here?
 

In my sheet, two columns Accounts & Descriptions exist. The entries would be
unique, that is for a particular Account only one type of description (e.g.
Pills) be there.

Now, I want is that
If accnt = 2345 AND descp = "pills" Then
do something
endif

Excel does not allow me do that. Can anyone help?

Milind


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 7/24/2003

Can the AND operator be of use here?
 

I'm not sure what your question is. Do you want a formula?

=IF(A1=2345,B1="pills"),"Yes","No")

Perhaps you could provide a few more details about what you need.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Milind" wrote in message
...
In my sheet, two columns Accounts & Descriptions exist. The
entries would be
unique, that is for a particular Account only one type of
description (e.g.
Pills) be there.

Now, I want is that
If accnt = 2345 AND descp = "pills" Then
do something
endif

Excel does not allow me do that. Can anyone help?

Milind


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 7/24/2003

Can the AND operator be of use here?
 

I think Chip meant to write:

=IF(AND(A1=2345,B1="pills"),"Yes","No")

Chip Pearson wrote:
I'm not sure what your question is. Do you want a formula?

=IF(A1=2345,B1="pills"),"Yes","No")

Perhaps you could provide a few more details about what you need.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Can the AND operator be of use here?
 

Yep, that's what I meant.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Debra Dalgleish" wrote in message
...
I think Chip meant to write:

=IF(AND(A1=2345,B1="pills"),"Yes","No")

Chip Pearson wrote:
I'm not sure what your question is. Do you want a formula?

=IF(A1=2345,B1="pills"),"Yes","No")

Perhaps you could provide a few more details about what you
need.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html