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