98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formula error
Formula error
Resolved · Medium Priority · Version 2007
Thu 4 Jun 2009, 15:52Delegate Alan said...
Alan has attended:
Access Introduction course
Access Intermediate course
Excel Intermediate course
Formula error
I have a spreadsheet on which each row requires a calculation but it could be one of three alternatives. If I use the same question calculation several times but then opt for one of the alternatives I get a wwarning about inconsistent calculations (even though it is correct). Can I change a default so that i do not get this warning every time (as long as the calculation is one of the three legitimate choices?
Mon 8 Jun 2009, 11:42Trainer Anthony said...
RE: Formula error
Hi Alan, thanks for your query. You can turn off error checking by going to Tools - Options - Error Checking and deselecting the "Enable Background Error Checking" option. This should get rid of the inconsistent formula alert.
Hope this helps,
Anthony
Mon 15 Jun 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Missing Field handleIf your field handle goes missing all you need to do is go to tools > options > edit tab and then make sure that the check boxes for paste and insert buttons are checked. |
