CODEWITHSUNDEEP
excelexcel-formulavba
Patrick Bender
Patrick Bender

Reputation: 467

Excel - Categorize lines of data based on 3 variables

I have the following problem: Sample

I have two sheets in the excel file that are included in this problem.

The first sheet contains the constraints for each group and is the first part of the picture.

The group “Correct 1” is a group where following restrictions are met:

“value 1” is between 0-1000

“value 2” is between 0-2000

“value 3” is between 0-500

_

The second sheet contains the data I want to label with the correct group based on the three values (1, 2 & 3).

For example:

The row labeled “info1” has three values connected to it.

value 1 = 321  “Correct 1” & “Correct 2”

Value 2 = 2005  “Correct 2”, “Correct 3” & “Error”

Value 3 = 400  “Correct 1”, “Correct 2” & “Error”

The Info1 line will therefore be labeled “Correct 2” since that group applies to all values.

Is this possible? Formula or VBA are both fine :)

Upvotes: 0

Views: 196

Answers (1)

Pqqwetiqe
Pqqwetiqe

Reputation: 314

=IF(B2<1001,IF(C2<2001,"Correct 1","Correct 2"),IF(D2<401,"Error","Correct 3"))

Upvotes: 1

Related Questions