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")))

[TABLE="class: grid, width: 316"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Names[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]Soft[/TD]
[/TR]
[TR]
[TD]Pineapple[/TD]
[TD]Hard[/TD]
[/TR]
[TR]
[TD]Apple, Orange, Watermelon[/TD]
[TD]Check Names[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]Soft[/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]Soft[/TD]
[/TR]
[TR]
[TD]Watermelon, Pineapple[/TD]
[TD]Check Names[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

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

You are very welcome.