Formulas issues in Excel 2016 ? Please Help

+1 vote
asked Oct 4, 2017 in MS Excel Issues by taylor (350 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, 2017 by alva (640 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.