Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie: doryna_2223
| Femeie 25 ani Mehedinti cauta Barbat 25 - 80 ani |
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 739
|
|
The IFS function syntax is:
=IFS(logical_test1; value_if_true1; logical_test2; value_if_true1; ... etc.)
As you can see, the IFS function does not have a built-in default value to use when all conditions are FALSE.
However, to provide a default value, you can enter TRUE as a final logical_test, followed by a value to use as a default.
* * * * *
See my example below:
=IFS([@[Stadiu / anulat]]=1;"NO";OR(WEEKDAY(TODAY();2)=6;WEEKDAY(TODAY();2)=7);"NO";[@Termen]="";"NO";[@Termen]-TODAY()>[@[Zile alerta]];"NO";"TRUE";"YES")
* * * * *
Example from source with explanations:
In the example below, a status code of 100 is "OK", a code of 200 is "Warning", and a code of 300 is "Error". Any other code value is invalid, so TRUE is provided as the final test, and "Invalid" is provided as a "default" value.
=IFS(A1=100,"OK",A1=200,"Warning",A1=300,"Error",TRUE,"Invalid")
When the value in A1 is 100, 200, or 300, IFS will return the messages shown above. When A1 contains any other value (including when A1 is empty) IFS will return "Invalid". Without this final condition, IFS will return #N/A when a code is not recognized.
* * * * *
Please see the source for examples on how to use the IFS function in different situations (grades - lowest to highest, rating - highest to lowest etc.)
Source:
|
|
pus acum 2 ani |
|