In a Microsoft Excel spreadsheet, you may have formulas sitting in one cell that require the information within another cell in order to calculate. These relationships are called references. When a ...

Microsoft Excel is designed to alert users whenever a circular reference is causing problems. Folks who are unable to spot the error can take full advantage of the ...

Office Q&A: Excel referencing, Word field codes, and a table trick Your email has been sent It’s been a month of easy answers for the most part. The problems seem big, but as usual, there’s an easy ...

Each cell in an Excel spreadsheet has a unique address, called a cell reference. This reference combines the letter that represents the cell's column with the number that represents its row. Cells in ...

(1) A programming conflict whereby the operation of each of two routines requires the result from the other routine. See recursion. (2) In a spreadsheet, a conflict in which the formula computes the ...

Formulas in Microsoft Excel can contain a wide range of symbols, such as the asterisk (*), the question mark (?), and the "at" (@) sign. Among the most important are parentheses, square brackets, and ...