Iconic game with the IF function
Solved
Tudiea
Posted messages
6
Status
Member
-
Vaucluse Posted messages 27336 Registration date Status Contributor Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributor Last intervention -
Hello
I’m starting with Excel and discovering the many possibilities, but despite that I can’t get what I want.
I would like to display, based on the result: won, lost, in progress... a green, red icon...
The icons are only used with numeric data, so I thought of the IF function which I don’t master very well. If Won, display 1, if in progress display 2... then apply formatting with the icon sets.
Thank you for your help
I’m starting with Excel and discovering the many possibilities, but despite that I can’t get what I want.
I would like to display, based on the result: won, lost, in progress... a green, red icon...
The icons are only used with numeric data, so I thought of the IF function which I don’t master very well. If Won, display 1, if in progress display 2... then apply formatting with the icon sets.
Thank you for your help
1 answer
-
Hello
=IF(A1="Won";1;IF(A1="Lost";2;... etc)))
and close with as many parentheses as there are IFs
... but you can directly display a Widget in cell B1 with a formula MFC
format B1 in Wingdings font and place the formula:
=IF(A1="Won";"J";IF(A1="Lost";"L";"K"))
and see the result
you can assign to this cell a MFC per formula:
=B1="J" > green format
=B1="L" > red format
this is just an example, you can see the characters and their font formatting by selecting B1 / Ribbon / Insert/ Symbol and inserting
crdlmnt
Errare humanum est, perseverare diabolicum
