Forum Discussion
CORRECT AN EXCEL FUNCTION
Please help me correcting this function :
=SI.CONDITIONS(S8=AZ7;"5";S8=AZ8;"4";S8=AZ9;"3";S8=AZ10;"2";S8=AZ11;"1")
Many thanks
8 Replies
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?
