New Functions

Excel 2013 comes with 50 new functions, which brings the total number of Excel functions to now 458 !

Financial

  • PDURATION
  • RRI

Logical

  • XOR

Text

  • NUMBERVALUE
  • UNICHAR
  • UNICODE


Date & Time

  • DAYS
  • ISOWEEKNUM

LOOKUP & REF

  • FORMULATEXT

MATH

  • ACOT
  • ACOTH
  • ARABIC
  • BASE
  • CEILING.MATH
  • COMBIN
  • COMBINA
  • COT
  • COTH
  • CSC
  • CSCH
  • DECIMAL
  • FLOOR.MATH
  • MUNIT
  • SEC
  • SECH

Statistical

  • BINOM.DIST.RANGE
  • GAMMA
  • GAUSS
  • PERMUTATIONA
  • PHI

Engineering

  • BITAND
  • BITLSHIFT
  • BITOR
  • BITRSHIFT
  • BITXOR
  • IMCOSH
  • IMCOT
  • IMCSC
  • IMCSCH
  • IMDIV
  • IMSEC
  • IMSECH
  • IMSINH
  • IMTAN

Information

  • ISFORMULA
  • SHEET
  • SHEETS

Web

  • ENCODEURL
  • FILTERXML
  • WEBSERVICE

1 comment

  1. Erick Saucedo

    Hi!;

    I just got a new pc on work, this one has Windows 7 Ultimate 64 bits, Excel 2013, and my job consist to calculate sales & service as well, work too much with formulas in Excel (as lookv, if, if.error, sum, etc..), and sometimes introduce even 4 o 5 formulas (or functions “as you guys saying”), in a row!, but i just realize, this Excel 2013, do not aloud me introduce the formula direct to the cell, if i write: =if.error(lookv(A1, ), send me a message asking if i want to introduce a formula, and has to use the “formula menu”, than ├»nsert a function”, and for me, is a waist of time!, i know very well the formula i need!, and a like to introduce typing my self to the cell with no problem!.

    What i need to “change”or “de-activate” on Excel to work as Excel 2007 o 2010?, it’s urgente for me!, i been trying to get use to work in this way, but it’s really a lot of waiste of my time.

    Can you help me?

    Thanks!, i really appreciate this!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>