Formulas issues in Excel 2016 ? Please Help

0 votes
asked Oct 4 in MS Excel Issues by taylor (300 points)

Hii, this is jack, i am using excel 2016 and while working on it I am getting the formula error. My formulas are not working in my Excel 2016 and when I tried the same formula in my friend system it worked fine. I guess I am facing the formulas error in Excel 2016.

Can anyone suggest me, how to get rid of the error? Please Help. 

1 Answer

0 votes
answered Oct 4 by alva (260 points)

To fix the formula error in Excel 2016, follow the steps

First, select the green triangle cell and click the Error button. This small button appears beside a cell with a formula error, click the icon and the drop-down list offers the prospect for correcting formula errors and find out more about them.

Or else you can also run the Error Checker.

To run the error checker, go to Formulas tab > click Error checking button (you might need to click the Formula Auditing button first, depending on the size of your screen).

Or to know more about Excel 2016 issues visit: 9 Excel 2016 Issues & Their Fixes That You Can’t Ignore

Welcome to Q&A - Repair MS Excel File, where you can ask questions and receive answers from other members of the community.