Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Operator for Contains | Excel Worksheet Functions | |||
Operator | Excel Worksheet Functions | |||
IN operator | Excel Worksheet Functions | |||
OR Operator | Excel Worksheet Functions | |||
Or operator | Excel Worksheet Functions |