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