HB473_1-1_FORMULA_SEP7

# HB473_1-1_FORMULA_SEP7 - Formulas BasicFormulas...

This preview shows pages 1–12. Sign up to view the full content.

Formulas Basic Formulas Copying and Pasting Formulas Complex Formulas Auditing Formulas

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Basic Formulas Most basic method of  performing calculations Basic formulas are defined  as any equations that consist  of two variables separated by  a mathematical operator. Figure 3.1 shows  Mathematical operator  symbols used in Excel. Symbol O + A - S / D * M ^ P

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Operation Addition Subtraction Division ( ÷ ) Multiplication ( × ) Power/ Exponent
Gross Sales Returns Net Sales Cost of Goods S Gross Profits Gross Sales - Re How to Produce Formula:Net  Must begin with equal (=)  sign If = sign is omitted, I10 – I11 will be  displayed in I12. By using cell references Any value typed into cell I11 will be  subtracted from any value typed in  cell I10. Common mistakes : U sing a calculator and typing the result into a spre - Typing computed results into a spreadsheet com eliminates Excel’s cell referencing capabilities.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Financial Plan 2008 2009 2010 \$100,000,000 \$110,000,000 \$115,000,000 \$4,000,000 \$550,000 \$600,000 \$410,000,000 \$451,000,000 \$430,000,000 \$54,000,000 \$59,400,000 \$59,900,000 eturns = Net Sales t Sales  adsheet. pletely
Relative Reference Relative referencing will  adjust cell references. Without relative referencing, you  would have to retype every formula  in a worksheet even though it may  be performing the same  mathematical function.  Notice changes in row numbers  for the cell references.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Hotel Global Performance in July 2010 Region Occ % ADR RevPAR Americas 67.9% 100.93 Asia Pacific 67.3% 124.69 Europe 70.9% 131.39 Middle East/Africa 61.3% 145.00 RevPAR = Occ * ADR mulas:
Monday Tuesday Wednesday Thursday Friday Paste Specials Contains a few commonly  used commands from the  Paste Special dialog box  Key Options Formats All except borders Formulas Transpose

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Item Cell Phone 2.75 Fuel Cost per Gallon Complex Formulas Any equations that consist  of more than two variables  and requires two or more  mathematical operators are  complex. Order of mathematical

This preview has intentionally blurred sections. Sign up to view the full version.

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

## This note was uploaded on 09/10/2010 for the course IAH 001 taught by Professor Wang during the Spring '10 term at Michigan State University.

### Page1 / 35

HB473_1-1_FORMULA_SEP7 - Formulas BasicFormulas...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online