If a part of a formula is in parentheses that part

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: alculating results. • If a part of a formula is in parentheses, that part will always be calculated before the rest of the formula. o The formula =(B2*C2)-A3 will subtract data in cell A3 from the multiplied product of cells B2 and C2. • After expressions in parentheses, Excel will calculate your formula using the math operators in the following order o Multiplication o Division o Addition o Subtraction • In other words, Excel will begin to parse your formula starting with any multiplication and division. Once this is complete, Excel will add and subtract the remainder of your formula. Inserting a function Each of Excel’s functions is a predefined formula, and most act on a range of cells that you select. (Excel refers to each range of cells in the function as an argument.) Although a few functions do not use arguments, most have one or more and some complex functions use as many as 3 or 4 arguments. Excel provides a Paste Function window to simplify the process of inserting functions into your worksheets and eliminate the need to remember the...
View Full Document

This document was uploaded on 03/12/2014.

Ask a homework question - tutors are online