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

=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

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.
--
David Biddulph

"Bob Umlas" wrote in message
...
=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

Bob just DOESN'T make mistakes. Therefore, it must be true.

--
Don Guillett
SalesAid Software

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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.
--
David Biddulph

"Bob Umlas" wrote in message
...
=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

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

try this
if(or(a1=99292,a1=99354,a1=99356,a1="simple"),b1,c 1)

--
Don Guillett
SalesAid Software

"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

One way ..

Put in D2:
=IF(A2="","",IF(ISNUMBER(MATCH(A2,{99354;99356;"SI MPLE";99292},0)),B2,C2))
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Constance" wrote:
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

=IF(OR(A2=99292,A2=99354,A2=99356,A2="SIMPLE"),B2, C2)
--
David Biddulph

"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

Simplified version

=IF(OR(A1={99292,99354,99356,"SIMPLE"}),B1,C1)


"David Biddulph" wrote:

=IF(OR(A2=99292,A2=99354,A2=99356,A2="SIMPLE"),B2, C2)
--
David Biddulph

"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