Using AND/OR functions

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

Guest

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.
 
One way ..

Put in D2:
=IF(A2="","",IF(ISNUMBER(MATCH(A2,{99354;99356;"SIMPLE";99292},0)),B2,C2))
Copy down
 
Are you sure, Bob?

99354 and 99356 both evaluate as TRUE, so the OR wouldd always be TRUE, but
Excel doesn't like the text string "SIMPLE" being included in the OR
function, so gives a #VALUE error.
 
Back
Top