Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
then you are making stuff up and using a mythical QDB or quadruple declining
balance. You could use a factor of 11 for HDB or Hendecuple Declining Balance
but you might end up in tax court. (This is my 24th book that I’ve written but
the fi rst time I ever used the word Hendecuple). If switch is FALSE, then the
calculation switches over to straight-line as soon as that method would yield a
higher depreciation.
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
[Category: Lookup & Reference]
Searches for a value in the leftmost column of a table, and then returns a value
in the same row from a column you specify in the table. Use VLOOKUP instead
of HLOOKUP when your comparison values are located in a column to the left of
the data you want to fi nd. Guru Tip: VLOOKUP is the workhorse of Excel, says
guru John Conmy. Use VLOOKUP to fi nd the description for an item number as
shown below.
WEEKDAY(serial_number,return_type) [Category: Date & Time]
Returns the day of the week corresponding to a date. The day is given as an
integer, ranging from 1 (Sunday) to 7 (Saturday), by default. Guru Tip: The
return_type argument controls the results. Use a return type of 1 and the days
are numbered as 1 for Sunday, 2 for Monday, … 7 for Saturday. If you use a
return type of 2, then Monday is 1 and Sunday is 7. If you use a return type of 3,
then Monday is zero and Sunday is 6. Also see page 7.
 
Search JabSto ::




Custom Search