I created the following IFS statement on excel 365, but it will not work when the file is transferred to Excel 2010. How would I change it to work on the 2010 version? =_xlfn.IFS([@[RESP. NECESSARY?]]="No","No",[@[RESP. NECESSARY?]]="","",[@[RESP. NECESSARY?]]="Yes",[@[DATE SERVED]]+30)
Solved by F. F. in 29 mins