IF condition

[Sahitya]

I have to change the name as per the group in 'Type' column. it is working fine if it is represented as single name, but not with multiple names.

Eg., For Apple, Orange, Watermelon, it should come as Medium, Soft

Formula used in 'Type' Column -

=IF(OR([@Names]="Orange",[@Names]="Watermelon",[@Names]="Banana"),"Soft",IF([@Names]="Apple","Medium",
IF([@Names]="Pineapple","Hard",
"Check Names")))

Names	Type
Orange	Soft
Pineapple	Hard
Apple, Orange, Watermelon	Check Names
Orange	Soft
Banana	Soft
Watermelon, Pineapple	Check Names

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[Aladin Akyurek]

You are real saviour for me. Thank you very much Mrexcel.

You are very welcome.