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

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!