Using AND/OR functions
Have you test your formula?
"Bob Umlas" wrote:
=IF(OR(A1=99292,99354,99356,"SIMPLE"),B1,C1)
(and fill down)
Bob Umlas
Excel MVP
"Constance" wrote in message
...
Hello,
I've never quite figured out how to use these functions but I think one of
these would work for what I want to do so I need some help in ascertaining
how to write a formula.
For example, in the situation below, if the Code in Column A is 99292,
99354, 99356, or SIMPLE, I want the formula result in Column D to equal
the
Occur in column B, and if the Code is column A is anything else I want the
formula result in Column D to equal the Units in Column C.
Code Occur Units Formula
99354 1 3
99356 1 2
99211 2 2
99212 4 4
SIMPLE 3 6
99292 2 4
Any help is appreciated!
Thanks.
--
Constance
|