Justin Greenwood
Member
Ok I know you have already probably seen in Excel 2016 we now have a IFS formula so no more IF IF IF IF IF IF IF
Hi,Ok I know you have already probably seen in Excel 2016 we now have a IFS formula so no more IF IF IF IF IF IF IF
As I thought... doesn't work in PT-PT version of Excel 2016Sure here you go its just a simple one.
IFS function
This article describes the formula syntax and usage of IFS, one of the logical functions in Microsoft Excel.
IMPORTANT This function is available if:
- You are an Office 365 subscriber and have the latest version of Office installed on your PC.
Thank you... I don't have admin permissions to reinstall office on this machine but will try later at home where I do.This could be why:
The solution however is to log into your 365 account, and select to install 365 on the machine again. This allowed the function to appear when enter into a cell.