| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XL2003 FILTER FUNCTIONS VS. XL2007 FILTER FUNCTIONS | Excel Worksheet Functions | |||
| Help with functions | Excel Worksheet Functions | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
Threaded Mode
