Hello!
In Excel there is "IFS" function.
Do you know how does it name in Numbers? Or which function can I use instead of that? (You can read about it on the link below.
https://support.office.com/en-us/article/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45
Thank You very much!
[Re-Titled by Moderator]
Mac mini, macOS 10.15
IFS appears to be functionally similar to the use of a lookup table and VLOOKUP or a combination of INDEX and MATCH.
Here's a VLOOKUP version of the Grades example on the oage lik=nked above.
Regards,
Barry
you can combine the functions
IF() and
AND()
like this:
IF(AND(<BOOLEAN_TEST1>,..,<BOOLEAN_TESTN>), <RESULT_WHEN_TRUE>, <RESULT_WHEN_FALSE>)
<BOOLEAN_TEST1> and <BOOLEAN_TESTN> must be proper expressions that result in a boolean (TRUE or FALSE) result
In Excel there is "IFS" function. Do you know how does it name in Numbers?
