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?
Hi Thomas,
Strange, Excel has compatibility back. In which formula he has an error?
- 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
- It is a multiple if statement using information from a ranking statement
