Excel Formula Cheat-sheet, Lecture notes of MS Microsoft Excel skills

Download Excel Formula Cheat-sheet and more Lecture notes MS Microsoft Excel skills in PDF only on Docsity! $#@$!! Errors, What to do Excel Formula For … The $s in FormulasSyntax : Top Excel Formulas Excel Formula Cheat-sheet Chandoo.org IF ( some condition, value if true, value if false ) SUM ( value 1, value 2 … ) CONCATENATE ( text1, text2…) = text1&text2 works too COUNT ( range of cells ) COUNTIF ( range of cells, meeting this criteria ) SUMIF ( range of cells, meeting this criteria, [optional cells to sum-up] ) AVERAGE ( range of cells ) VLOOKUP ( lookup this, in this table, and get the value in this column, [is the list sorted?] ) MAX ( range of cells ) TODAY () Reference When dragged Down Sideways A1 A2 B1 A$1 A$1 B$1 $A1 $A2 $A1 $A$1 $A$1 $A$1 #NAME? Correct spellings of formulas & names. Add : to ranges #N/A Make sure the data you are looking for is there. Add ISERROR() if needed. #NUM! Is the number too big, like 37^5759435 big? #REF! Did you just remove a name or cell used by the formula? #VALUE! Pass the correct parameters to formulas #DIV/0! Is the denominator zero? ####### Adjust column width Percentage =23/49 (and format the cell as %) Subtraction =49-23 Division =230/23 Multiplication =23*10 Average =AVERAGE(23,49) Today's Date =TODAY() Time Now =NOW() Compound Interest =100*(1+10%)^5 Mortgage Payment =PMT(4.5%/12,240,-100000) IF then ELSE =IF(23>49,"23 is big, but how?","49 is big")