I’ve got a spreadsheet with 6 columns and near the bottom of each are formulas like this, which work fine in five columns:
=YIELD(J4,J5,J6,J7,J8,J9,J10)
But now, this formula is displaying Err:502:
=YIELD(K4,K5,K6,K7,K8,K9,K10)
I’ve re-checked the data types of the arguments. (The first two are dates [Default English USA] and the rest are numbers/general.) And I’ve fiddled with the dates just to see if anything changes.
I’ve re-set my user profile, installed the latest ver. 24.8.6.2(x86_64), and rebooted the machine (Windows 11 Professional).
I’ve just copied the last two columns (J & K) into Columns L & M with the same result. L is okay and M has the same error. I’ve also pasted all columns into a clean, new spreadsheet. No help. The last column has this error.
Can anyone suggest what is going wrong and how to fix it?
Many thanks.