|
Using AND/OR functions
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 |
Using AND/OR functions
=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 |
Using AND/OR functions
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 |
Using AND/OR functions
=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 |
Using AND/OR functions
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 |
Using AND/OR functions
|
Using AND/OR functions
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 |
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 |
| All times are GMT +1. The time now is 10:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com