10

job preparation (Subject) / excel (Lesson)

.

This lesson was created by indemu.

Learn lesson

This lesson is not released for learning.

back  |  next 1 / 1

  • payment function PMT = RMZ Monthly payments on a loan of$50,000 that is to be paid off infull over 5 years, with an interestrate of 5% per year (paymentmade at end of each mth): =PMT( 5%/12, 60, 50000 )
  • sumproduct =sumproduct(area) addition der matritzenmultiplikation
  • VLOOKUP zeilenwert für eine Wert links finden! VLOOKUP(Wert,Matrix,Spaltenindex,Wahr/Falsch)
  • index match =INDEX(column with data you want,MATCH(value you are looking for, column which contains this data,0))
  • if function =if(a2=5;"cool";"fail") =IF (condition to test, output for TRUE, output for FALSE)
  • nesting formulas =if(A2=x;A2*r1;if(A2=y;A2*r2))
  • compounded interest Ke=Ka(1+p/100)^n =Anlagewert(1+Zins/100)^Laufzeit
  • Small, big, rank =small(A2:A4;3) drittkleinster =large(A2:A4;3) drittgrößter RANK: Finds the rank of a value in a list. Use it like =RANK(value, in this list, order)
  • iferror IFERROR(VLOOKUP(….), “Value not found!”)
  • makros Visual Basic Aufzeichnung
Advertisement

back  |  next 1 / 1