Workbook Functions D-H

 

DATE(year, month, day)

Serial number of the supplied date, where year is a number up to 9999 and month between 1 and 12.

See also: DATEVALUE, DAY, MONTH, NOW, TIMEVALUE, TODAY, YEAR

 

DATEVALUE(text)

Serial number of a date supplied in text format (e.g. "3/6/1994") up to the year 9999.

See also: NOW, TIMEVALUE, TODAY

 

DAY(serial number)

Day of the month that corresponds to the date represented by the given argument, be it a serial number (e.g. 34399) or a text (e.g. "21-06-1994").

See also: NOW, HOUR, MINUTE, MONTH, SECOND, TODAY, WEEKDAY, YEAR

 

DAY360(start_date, end_date, [method])

Number of days between two dates based on a 360 day year (twelve 30 day months). If method = true then the European system is used. If method = false or omitted then the US system is used.

 

DB(cost, salvage, life, period [, months])

Real depreciation of an asset for a specific period using the fixed-declining balance method. Cost is the initial cost of the asset, salvage is the salvage value of the asset and life is the number of periods in its useful life. Months is the number of months in the first year of the item's life (default is 12). The time units for life and period must match.

See also: DDB, SLN, SYD, VDB

 

DDB(cost, salvage, life, period [,factor])

Depreciation of an asset for a specific period of time using the double-declining balance method or a declining balance factor supplied. Factor is the rate at which the balance declines (default value is 2). All entries must be >0.

See also: DB, SLN, SYD, VDB

 

DOLLAR(number [,precision])

Returns the number as text, using currency format. The number of decimal places to the right of the decimal point is indicated by precision.

See also: FIXED, TEXT, VALUE

 

ERROR.TYPE(reference)

Number corresponding to an error occurring in the specified reference cell.

See also: ISERR, ISERROR

 

EVEN(number)

Rounds the specified number up to the nearest even integer.

See also: CEILING, FLOOR, INT, ODD, ROUND, TRUNC

 

EXACT(expresion1, expression2)

True if the two text expressions are identical (case-sensitive); False if not.

See also: LEN, SEARCH

 

EXP(Any number)

e (e=2.71828183) raised to the specified power.

See also: LN, LOG

 

FACT(Non-negative integer)

Factorial of a specified number.

See also: PRODUCT

 

FALSE( )

Logical value False.

See also: TRUE

 

FIND(search text, text [,start position])

Searches for the specified search text within another text and returns the character position at which the search string first occurs. Start position in text where the search begins (default is 1).

See also: EXACT, LEN, MID, SEARCH

 

FIXED(Any number [, precision][,no commas])

Rounds the number to the supplied precision. No commas determines if thousands separators (commas) are used in the result.

See also: DOLLAR, ROUND, TEXT, VALUE

 

FLOOR(Any number, significance)

Rounds a number down to the nearest multiple of a specified significance.

See also: CEILING, EVEN, INT, ODD, ROUND, TRUNC

 

FV(interest, number of payments per annuity, payment [,present value of annuity] [,type])

Future value of an annuity based on regular payments and a fixed interest rate. Type indicates when the payments are due: 0 for the end of period, 1 for the beginning of the period.

See also: IPMT, NPER, PMT, PPMT, PV, RATE

 

HLOOKUP(search item, search range, row index)

Searches the top row of the specified search range for the search item and returns the contents of the cell in the same column as the search item and row given by row index. Contents in first row must be in ascending order (e.g. -1,0,1,...A,...Z,FALSE,TRUE).

See also: INDEX, LOOKUP, MATCH, VLOOKUP

 

HOUR(serial number)

Hour component of the specified time (given as serial number) in 24 hour format.

See also: DAY, MINUTE, MONTH, NOW, SECOND, WEEKDAY, YEAR

 

 

Copyright © 2000-2016 StatsDirect Limited, all rights reserved. Download a free trial here.