IF Function not working on desktop app but OK online
I’ve been using excel on and off for over 20 years. My problem is that a simple IF statement works online but not on my desktop app.
=IF(C4=C5, “True”, “False”) was created online without errors and works, C4=1, C5=2
When I create the same on the desktop app I get this
I have the problem on both of my PC’s. If I use the formula wizard I get the same error.
Any help would be appreciated.
Dave.
I’ve been using excel on and off for over 20 years. My problem is that a simple IF statement works online but not on my desktop app. =IF(C4=C5, “True”, “False”) was created online without errors and works, C4=1, C5=2 When I create the same on the desktop app I get this I have the problem on both of my PC’s. If I use the formula wizard I get the same error.Any help would be appreciated. Dave. Read More