G
Guest
Hi there!
I would like a formula that checks through several levels of criteria before
returning the value.
So, for example, I have the following:
1 A B C D E
2 High 50 A
3 Med 40 B
4 Low 30 C
5 Others
Column A contains Labels that I want the formula to return after checking
the values in columns B and C.
Example 1:
An item has score of 50 (column B) and rating of "A" (column C). Therefore,
the formula will return the label of "High" (column A) for this item.
Example 2:
An item has score of 45 and rating of "B". As the score of Therefore, the
formula returns label of "Med" for this item.
Example 3:
An item has score of 50 and rating of "B". The item does have the score in
the "High" level. But since it has rating of "B", the formula will return
"Med" for this item.
Example 4:
An item has score of 55 and rating of "C". The formula will return label of
"Low" for this item.
Example 5:
An item has score of 35 and rating of "D". Since the item does not have a
rating of at least "C" in order to be labeled "Low". The formula will return
"others"
Hope U guys understand my question.
Cheers.
I would like a formula that checks through several levels of criteria before
returning the value.
So, for example, I have the following:
1 A B C D E
2 High 50 A
3 Med 40 B
4 Low 30 C
5 Others
Column A contains Labels that I want the formula to return after checking
the values in columns B and C.
Example 1:
An item has score of 50 (column B) and rating of "A" (column C). Therefore,
the formula will return the label of "High" (column A) for this item.
Example 2:
An item has score of 45 and rating of "B". As the score of Therefore, the
formula returns label of "Med" for this item.
Example 3:
An item has score of 50 and rating of "B". The item does have the score in
the "High" level. But since it has rating of "B", the formula will return
"Med" for this item.
Example 4:
An item has score of 55 and rating of "C". The formula will return label of
"Low" for this item.
Example 5:
An item has score of 35 and rating of "D". Since the item does not have a
rating of at least "C" in order to be labeled "Low". The formula will return
"others"
Hope U guys understand my question.
Cheers.