Forum Discussion
Re-calculating on two different machines results in errors on one, no errors on another
My company is running Office 365, Excel is specifically version: Excel for Microsoft 365 MSO (16.0.13001.20254) 64-bit, and a user outside of our org is using version: 2019 MSO (16.0.13001.20338). A file that we've sent to this 3rd party user doesn't calculate correctly after he opens the file and re-calculates the workbook. Specifically, a formula...
=@IF(F50="","",INDEX($BT$45:$HI$45,1,SUMPRODUCT(--(ROWS($B$50:$B50)>$BT$46:$HI$46))+1))
...returns as "#NAME" for this 3rd party user, however it does not for me and other users within my org. I'm assuming it has to do with the difference in versions? Is it as simple as removing the ampersand from the very beginning of the formula?
Yes, in general you may remove it. That's Implicit intersection operator: @
1 Reply
Yes, in general you may remove it. That's Implicit intersection operator: @