Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formula error

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Formula error

Resolved · Medium Priority · Version 2007

Reply 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?

For upcoming training course dates see: Pricing & availability

Reply 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.

Excel articles

· How We Got To The Perfect Spreadsheet: A Brief History
· How To Create An Excel Formula Using Data From Several Worksheets
· What Makes A Good Spreadsheet?
· Share And Share Alike - Use Excel To Collaborate As A Winning Team!
· Tell AutoFill What To Do And It Will Oblige

Please browse our web site to find out more about
excel course and other Microsoft training courses.

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips