Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Conditions for IF statement to evaluate
i have multiple branch numbers in one column. I want to do a pivot table
using an inserted column for financial planners. Is there a way to create a conditional or any other usable statement in Excel along the following logic? if cell y2 is one of (25,19,61), then "Sedric" if cell y2 is one of (8,4,31,33), then "Fred","") I am using Excel 2002. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Conditions for IF statement to evaluate
=if(or(y2={25,19,61}),"Sedric",if(or(y2={8,4,31,33 }),"Fred",""))
But if you're going to have more than a couple of these categories, you may find creating a table on a different sheet easier to update: 25 Sedric 19 Sedric 61 Sedric 8 Fred 4 Fred .... then use a formula like: =if(iserror(vlookup(y2,sheet2!a:b,2,0)),"",vlookup (y2,sheet2!a:b,2,0)) Debra Dalgleish explains it: http://www.contextures.com/xlFunctions02.html (for =vlookup()) Bees*Stars wrote: i have multiple branch numbers in one column. I want to do a pivot table using an inserted column for financial planners. Is there a way to create a conditional or any other usable statement in Excel along the following logic? if cell y2 is one of (25,19,61), then "Sedric" if cell y2 is one of (8,4,31,33), then "Fred","") I am using Excel 2002. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function evaluate multiple cells and return 1st one w/a value | Excel Discussion (Misc queries) | |||
IF Statement with multiple conditions | Excel Discussion (Misc queries) | |||
If statement using multiple conditions | Excel Worksheet Functions | |||
"OR" operator to evaluate multiple conditions | Excel Worksheet Functions | |||
COUNTIF Statement with Multiple Conditions in Different Ranges | Excel Worksheet Functions |