Hi Friends,
I’m trying to use windings for smileys but only getting happy face. Please see table below:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Skills (E12)[/TD]
[TD]Knowledge (F12)[/TD]
[TD]Attitude (G12)[/TD]
[TD]Behaviour (H12)[/TD]
[TD]Circumstance (I12)[/TD]
[TD]Staff Morale (J12[/TD]
[/TR]
[TR]
[TD="align: center"]Y[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]NA[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]NA[/TD]
[TD="align: center"]Formula Result[/TD]
[/TR]
</tbody>[/TABLE]
In cell J12, I want to show a happy face when cells E12 though I12 either show “Y” or “NA” and if any cell show “N” then show sad face. My formula only works well for the happy face but not giving any sad face. I used following formula but only getting a happy face.
=IF(OR(E12="Y",E12="NA"),IF(OR(F12="Y",F12="NA"),IF(OR(G12="Y",G12="NA"),IF(OR(H12="Y",H12="NA"),IF(OR(I12="Y",I12="NA"),"J","L")))))
Any help will be greatly appreciated!
Thanks,
Taha
I’m trying to use windings for smileys but only getting happy face. Please see table below:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Skills (E12)[/TD]
[TD]Knowledge (F12)[/TD]
[TD]Attitude (G12)[/TD]
[TD]Behaviour (H12)[/TD]
[TD]Circumstance (I12)[/TD]
[TD]Staff Morale (J12[/TD]
[/TR]
[TR]
[TD="align: center"]Y[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]NA[/TD]
[TD="align: center"]Y[/TD]
[TD="align: center"]NA[/TD]
[TD="align: center"]Formula Result[/TD]
[/TR]
</tbody>[/TABLE]
In cell J12, I want to show a happy face when cells E12 though I12 either show “Y” or “NA” and if any cell show “N” then show sad face. My formula only works well for the happy face but not giving any sad face. I used following formula but only getting a happy face.
=IF(OR(E12="Y",E12="NA"),IF(OR(F12="Y",F12="NA"),IF(OR(G12="Y",G12="NA"),IF(OR(H12="Y",H12="NA"),IF(OR(I12="Y",I12="NA"),"J","L")))))
Any help will be greatly appreciated!
Thanks,
Taha