Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 20 Dec 2025 11:10:23 +0000

How to Post a Message for Support

Post From: New Spreadsheets Syntax Error

[2016-11-18 12:25:02]
[Go To First Post]
user58907 - Posts: 83
Within the same spreadsheet window, I have a summary sheet which gets data from the other sheets.

This formula works in the old spreadsheets, not in the new.

=IF(SPX5m!K$3=0,0,+SPX5m!AA$3)

I have also tried =IF(SPX5m!K$3=0,0,=SPX5m!AA$3) and get the same error.


Please advise, thanks.