I have a spreadsheet in which I am using CONVERT to convert mass units to ozm. On the main spreadsheet (unfiltered), the calculations are fine. If I then filter the worksheet, the function reference still looks okay, but the returned result is incorrect.
Example in the Filtered View.
In the unfiltered view, the result is still 2 ozm like it should be.