Return Value Baed on Criteria

[Excel_77]

Hi All,

How do I incorporate this?

If column called Groupings = "Big" and the column "Sub Grouping" does not contain "Tasks" then return "Investment"

If column "Groupings" = "GDE" or "Tasks" return "Fail"

Everyone else return "Other".

 

[louisH]

Hi.

=IF(AND(Groupings="Big", ISNUMER(SEARCH("Tasks", Sub Grouping))=FALSE),"Investment", IF(OR(Groupings="GDE", Groupings = "Tasks"), "Fail", "Other"))

 

[Excel_77]

Hi.

=IF(AND(Groupings="Big", ISNUMER(SEARCH("Tasks", Sub Grouping))=FALSE),"Investment", IF(OR(Groupings="GDE", Groupings = "Tasks"), "Fail", "Other"))

It's bringing a "#NAME?" error, is the "ISNUMBER" correct?

 

[louisH]

It's bringing a "#NAME?" error, is the "ISNUMBER" correct?

The formula looks correct. Did you replace the "Groupings", "Sub Grouping" with your actual column name (if it's a table) or cell address ?
For example if Groupings is in column B, Replace "Groupings" with "B2" and copy the formula down.

 

[louisH]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Groupings[/TD]
[TD]Sub Grouping[/TD]
[TD]Formula[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Big[/TD]
[TD]Tasks[/TD]
[TD]=IF(AND(A2="Big", ISNUMER(SEARCH("Tasks", B2))=FALSE),"Investment", IF(OR(A2="GDE", A2 = "Tasks"), "Fail", "Other"))[/TD]
[/TR]
</tbody>[/TABLE]