SUM IF Function......

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that has a column which had a drop down menu of codes
(i.e. LV, DE, TR, AC, RT).

I would like to come u"p with a formula that will assign a number based on
the corresponding column's code.

For example:
If a column contains the code of AC or LV I would like "1" to show up.
If a column contains the code of DE, TR or RT I would like "0" to show up.

Any help would be GREATLY appreciated.

Thanks.
 
Show up where?
In another cell?

Say the drop downs are in ColumnA.
Try this:

=--OR(A1={"AC","LV"})

And copy down as needed.
 
Back
Top