SUM IF Function......
 

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.

SUM IF Function......
 

Show up where?
In another cell?

Say the drop downs are in ColumnA.
Try this:

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

And copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Reegan" wrote in message
...
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.