Forum Discussion
Aaron Fitzgerald
Nov 15, 2017Copper Contributor
IFS function not working
Hello, I recently brought a spreadsheet over to a new laptop and the IFS statements that I had been using are no longer recognized. I get the #NAME? error in all cells that are currently using th...
SergeiBaklan
MVP
You may try complete uninstall, that's option 2 here https://support.office.com/en-us/article/uninstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8. Uninstalling from Control Panel keeps some elements of the Office.
DamianoStella
Jan 27, 2020Copper Contributor
- DamianoStellaJan 27, 2020Copper Contributor
Thx, it worked. I had to run the Microsoft Support and Recovery Assistant a couple of time, and i succeded to remove the previous installation download the new and install it.
Now IFS works and a new "@" operator appeared in some formula.
best,
damiano
- SergeiBaklanJan 27, 2020MVP
DamianoStella , great, glad to know you sorted this out