Hi expertise,
I have 5 different values to be used in multiple cells. if cells contain all the value then, Unsatisfactory to be shown.
if cells contains all value except unsatisfactory then Inconsistent to be shown.
If cells contains all value except Unsatisfactory and Inconsistent then Effective to be shown. so on...
[TABLE="width: 146"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Exceptional[/TD]
[/TR]
[TR]
[TD]Excellent[/TD]
[/TR]
[TR]
[TD]Effective[/TD]
[/TR]
[TR]
[TD]Incosistent[/TD]
[/TR]
[TR]
[TD]Unsatisfactory
Please can you write a formula with if or any other formula you can suggest would be great help[/TD]
[/TR]
</tbody>[/TABLE]
I have 5 different values to be used in multiple cells. if cells contain all the value then, Unsatisfactory to be shown.
if cells contains all value except unsatisfactory then Inconsistent to be shown.
If cells contains all value except Unsatisfactory and Inconsistent then Effective to be shown. so on...
[TABLE="width: 146"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Exceptional[/TD]
[/TR]
[TR]
[TD]Excellent[/TD]
[/TR]
[TR]
[TD]Effective[/TD]
[/TR]
[TR]
[TD]Incosistent[/TD]
[/TR]
[TR]
[TD]Unsatisfactory
Please can you write a formula with if or any other formula you can suggest would be great help[/TD]
[/TR]
</tbody>[/TABLE]