Hi,
I've recently been given a QA check sheet created by a colleague in Office 365 Excel version 1909, I am using Excel V 14.0.7327.5000.
The idea of the spreadsheet is that coordinate values are input in the "Input_Sheet", with the differences in the results displayed on the "Front_Sheet".
In the example attached I have changed the coordinate values for the "CHANGED" coordinate. In theory the difference calculated should be zero, but I'm just getting "#NAME?" displayed.
Any advice or help would be greatly appreciated.
Thanks,
Sam
Bookmarks