#Name error when the document is opened by the person on another machine

[Adar123]

Hi everyone,

For some reason, when my colleague opens an Excel document on her machine, several IFS functions start giving #Name? error and appear with curly brackets { }.
I don't have such an issues, the function is as follows:

=IFS(YEAR(H$6)<YEAR($G$6)+'Control Panel'!$F$46,0,YEAR(H$6)=YEAR($G$6)+'Control Panel'!$F$46,-SUM('Active OO Model'!H69:H70),YEAR(H$6)>YEAR($G$6)+'Control Panel'!$F$46,0)

Any suggestions as to why this could be happening?

Thank you.

 

[etaf]

what version of excel are you using and what version is she using
IFS() was added in 2019 version

Excel IFS Function - BetterSolutions.com

How to use the Excel IFS function to return the value based on multiple True or False conditions.

bettersolutions.com

you are showing 2016/2010 in your profile
that maybe the issue, if you are using a later version and she is NOT

If you could update your profile to just show the version of excel you have - would help