• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

No more nested IF statments Yipppeee!

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,

Yes... although I am still struggling to find the Portuguese version of this.
Can you upload a file with the formula in place so I can see how my version of excel translates it?
Thank you
 
This could be why:
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:

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.
 
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.
Thank you... I don't have admin permissions to reinstall office on this machine but will try later at home where I do.
 
Back
Top