Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

VALUE(text) [Category: Text]

Converts a text string that represents a number to a number. Guru Tip: Guru

Jonathon Broughton uses this function for all the times that others enter numbers

as text indiscriminately. In the ﬁ gure below, VALUE handles text, spaces, plus

signs, minus signs, and even scientiﬁ c notation. It will not work with the word

"one", though.

VAR(number1,number2,...) [Category: Statistical]]

Estimates variance based on a sample.

VARA(value1,value2,...) [Category: Statistical]]

Estimates variance based on a sample. In addition to numbers, text and logical

values such as TRUE and FALSE are included in the calculation.

VARP(number1,number2,...) [Category: Statistical]]

Calculates variance based on the entire population.

VARPA(value1,value2,...) [Category: Statistical]]

Calculates variance based on the entire population. In addition to numbers, text

and logical values such as TRUE and FALSE are included in the calculation.

VDB(cost,salvage,life,start_period,end_period,factor,no_switch)

[Category: Financial]

Returns the depreciation of an asset for any period you specify, including partial

periods, using the double-declining balance method or some other method you

specify. VDB stands for variable declining balance. Guru Tip: There are many

depreciation functions in Excel: SLN, DB, DDB, SYD. The VDB method handles

does SLN, DB, and DDB better than those individual functions do them. You

can specify partial periods with VDB. If Factor is 1, then you are using DB. If

factor is 2, then you are using DDB or double declining balance. If Factor is 4,