get-digital-help.com

NA function

Excel » Functions » Information » NA function »

How to use the NA function

The NA() function returns the error value #N/A meaning "value is not available". Formula in cell B3: =NA() Excel Function […]

Excel functions

BETADIST function

BETAINV function

CHIDIST function

CHIINV function

CHITEST function

FORECAST function

QUARTILE function

DAVERAGE function

DCOUNT function

DCOUNTA function

DPRODUCT function

DSTDEV function

DSTDEVP function

DATEDIF function

DAYS function [2013]

EOMONTH function

MINUTE function

NETWORKDAYS.INTL [2010]

SECOND function

WEEKDAY function

WEEKNUM function

WORKDAY function

YEARFRAC function

BIN2DEC function

BIN2HEX function

BIN2OCT function

BITAND function [2013]

BITLSHIFT [2013]

BITOR function [2013]

BITRSHIFT [2013]

BITXOR function [2013]

COMPLEX function

CONVERT function

DEC2BIN function

DEC2HEX function

DEC2OCT function

ACCRINT function

ACCRINTM function

AMORLINC function

CUMIPMT function

CUMPRINC function

DOLLARFR function

EFFECT function

NOMINAL function

PRICEMAT function

ISBLANK function

ISERROR function

ISFORMULA [2013]

ISNUMBER function

ISTEXT function

SHEETS function

IFERROR function [2007]

IFNA function [2013]

IFS function [Office 365]

SWITCH function [2016]

XOR function [2013]

Lookup and reference

ADDRESS function

CHOOSE function

COLUMN function

COLUMNS function

FORMULATEXT [2013]

HLOOKUP function

INDIRECT function

LOOKUP function

OFFSET function

VLOOKUP function

Math and trigonometry

ACOT function [2013]

ACOTH function [2013]

CEILING function

COMBIN function

COMBINA function [2013]

COT function [2013]

COTH function [2013]

DECIMAL function [2013]

DEGREES function

FLOOR.MATH [2013]

FLOOR.PRECISE [2010]

MINVERSE function

MROUND function

MUNIT function [2013]

PRODUCT function

QUOTIENT function

RADIANS function

ROUNDUP function

SUBTOTAL function

SUMIFS function [2007]

SUMX2MY2 function

SUMX2PY2 function

SUMXMY2 function

AVEDEV function

AVERAGE function

AVERAGEA function

AVERAGEIF [2007]

AVERAGEIFS [2007]

BETA.DIST [2010]

BETA.INV function [2010]

BINOM.DIST [2010]

BINOM.INV [2010]

CHISQ.DIST.RT [2010]

CHISQ.INV [2010]

CHISQ.INV.RT [2010]

CHISQ.TEST [2010]

CONFIDENCE.NORM [2010]

CONFIDENCE.T [2010]

CORREL function

COUNTA function

COUNTIF function

COUNTIFS function [2007]

COVARIANCE.P [2010]

COVARIANCE.S [2010]

EXPON.DIST [2010]

F.DIST function [2010]

F.DIST.RT [2010]

F.TEST function [2010]

FORECAST.LINEAR [2016]

GAMMA function [2013]

GAMMA.DIST [2010]

GEOMEAN function

GROWTH function

LINEST function

LOGEST function

LOGNORM.DIST [2010]

MAXIFS function [2016]

MEDIAN function

MINIFS function [2016]

MODE.MULT [2010]

MODE.SNGL [2010]

NORM.DIST [2010]

NORM.INV function [2010]

PERCENTRANK.EXC [2010]

PERCENTRANK.INC [2010]

PERMUT function

QUARTILE.EXC [2010]

QUARTILE.INC [2010]

RANK.AVG function [2010]

RANK.EQ function [2010]

STDEV.P function [2010]

STDEV.S function [2010]

STDEVA function

STDEVPA function

TRIMMEAN function

VAR.P function [2010]

VAR.S function [2010]

CONCAT function [Office 365]

SEARCH function

TEXTJOIN function [Office 365]

UNICHAR function [2013]

UNICODE function [2013]

ENCODEURL [2013]

WEBSERVICE [2013]

<a href="//pixfuture-d.openx.net/w/1.0/rc?cs=45edad9c62&cb=INSERT_RANDOM_NUMBER_HERE" ><img src="//pixfuture-d.openx.net/w/1.0/ai?auid=538803742&cs=45edad9c62&cb=INSERT_RANDOM_NUMBER_HERE" border="0" alt=""></a>

Weekly Blog EMAIL

Get a FREE PDF book!

Welcome! I am Oscar and here to help you out.

Feel free to comment and ask Excel questions.

Make sure you subscribe to my newsletter so you don't miss new blog articles.