Forum Discussion

Copper Contributor

Sep 18, 2018

IFS(OR(ISNUMER(SEARCH( function

Is there a way to simplify this part of my IFS function: IFS(OR(ISNUMBER(SEARCH("aanvraag opleiding",F619)),ISNUMBER(SEARCH("Aanvraag cursus",F619)),ISNUMBER(SEARCH("Toekenning aanvraag",F619)),I...

excel

office 365

SergeiBaklan

Diamond Contributor

Feb 22, 2019

Yes, IFS is not available for 2010 https://support.office.com/en-us/article/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45

KRISTEN_

Copper Contributor

Feb 28, 2019

Is it ok to use Ms Office 2016?

SergeiBaklan wrote:
Yes, IFS is not available for 2010 https://support.office.com/en-us/article/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45

SergeiBaklan
Diamond Contributor
Mar 01, 2019
You may check availability here https://support.office.com/en-us/article/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45
KRISTEN_
Copper Contributor
Feb 28, 2019
"IFS" is not recognized in 2016. Should I use 2019 instead?