Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to show marks (◎, 〇, △, ×)according to the condition below.
Index >1.1 → ◎
Index >1.0 → 〇
Index >0.9 → △
else → ×
Does anyone know how to set the formula for this?
(may be like: If (Index =>1.1 '◎', =>1.0 '〇', 0.9=> '△', ×)?)
Thank you.
If (index>=1.1 ,Chr(9678),
If (index>=1.0 and index<1.1 ,'〇',
If (index>=0.9 and index<1.0,Chr(9651),
chr(9685))
)
)
This should work for you - I tested it quickly and it works for me:
Pick( Match( Index , 1.1 , 1.0 , 0.9 ) + 1 , '×' ,'◎', '〇', '△', '×')
... sorry my suggestion had an extra 'x' at the end that is not needed.
This should be sufficient:
Pick( Match( Index , 1.1 , 1.0 , 0.9 ) + 1 , '×' ,'◎', '〇', '△')
If (index>=1.1 ,Chr(9678),
If (index>=1.0 and index<1.1 ,'〇',
If (index>=0.9 and index<1.0,Chr(9651),
chr(9685))
)
)
Thank you!
But it doesn't show any results...↓
The value of index look like this↓
So maybe there should be "> "?
Thank you very much!
It worked.
I didn't know about this Character code !
Pick(Match(-1, INdex >=1.1
, INdex >=1.0 and INdex <1.1,
INdex >=0.9 and INdex <1.0), Chr(9678),'〇',Chr(9651),'x')