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:
Any suggestions as to why this could be happening?
Thank you.
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:
Excel Formula:
=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.