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