Forum Discussion
Formula Errors
So I have sent a spreadsheet to a coworker. I use excel 2010 and he uses 2016. The formulas work on my end but on his they result in #DIV errors. Any ideas?
It is a if statement tied to a ranking statement on another spreadsheet(same file)
have you checked if there are more than 7 IFs?
Otherwise could you paste your formula please?
Remember there are some new formulas unlike at 2010 so if there is an issue could be that somehow it returned a different value because of if
Carlos, for my interest, which functions work in 2010 and don't work in 2016?
In general yes, hard to say without the sample. That could difference in floating point operations, especialy if that's 32 and 64 bit versions. Could be difference in settings. Whatever. Even another bug in Excel.
