Forum Discussion
CORRECT AN EXCEL FUNCTION
Hi Thomas,
I guess in English version that's IFS. What's wrong with that functions? Looks okay. Of course if your list separator is semicolon, not comma.
Hi Sergei, thanks for your interest.
Actually, i am trying to build a scoring where :
- S8=Major; "1" or
- S8=Valuable;"2" or
- S8=Average;"3" or
- S8=Weak;"2" or
- S8=Null;"1"
It seems there are too many conditions for Excel capacity
What do you think ?
Thomas,
To clarify a bit - if in S8 one of texts ("Major", etc.) you'd like to return by formula into some cell another text ("1", etc.)?
And what to return if S8 doesn't match any from the list?
Sorry Sergei, i am french and don't understand well what you mean.
In S8, it is a drop-down band from "Major" to "Null".
According to the choice made, the cell X8 will show a rating from 5 (best) to 1 (worst).
Dear all, i thank you for your help.
Finally, i have found the exact formula which i a sharing with you as follows :
=SI(S8="Majeur";5;SI(S8="Fort";4;SI(S8="Moyen";3;SI(S8="Faible";2;SI(S8="Nul";1)))))
Many thanks to you all