View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Milind Milind is offline
external usenet poster
 
Posts: 13
Default 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