In Microsoft Excel, use the IFS function to check whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.  

For more tips like this, check out the working remotely playlist at www.youtube.com/FoetronAcademy . Also, if you need any further assistance then you can raise a support ticket and get it addressed.