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 fi gure below, VALUE handles text, spaces, plus
signs, minus signs, and even scientifi 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,
 
Search JabSto ::




Custom Search