Frequently Asked Questions

Q:

Which functions fall within which categories?

A:

Functions

Date and Time
• D360

• DATE

• DATEVALUE

• DAY

• MONTH

• YEAR

• HOUR

• MINUTE

• SECOND

• TIME

• TIMEVALUE

• NOW

• TODAY

String
• CHAR

• CODE

• EXACT

• FIND

• LEFT

• LENGTH

• LOWER

• MID

• N

• PROPER

• REPEAT

• REPLACE

• RIGHT

• S

• STRING

• TRIM

• UPPER

• VALUE

Financial
• DDB(cost,salvage,life,period)

• SLN(cost,salvage,life)

• SYD(cost,salvage,life,period)

• VDB(cost,salvage,life,start-period,end-period[,depreciation][,switch])

• IRR(guess, range)

• NPV(interest-rate,range)

• FV(payment, interest, term)

• PMT(principal, interest, term)

• PV(payment, interest, term)

• TERM(payments, interest, futurevalue)

• CTERM(interest, future-value, present-value)

• RATE(future-value, present-value, term)

Mathematical
• ABS

• ACOS

• ASIN

• ATAN

• ATAN2

• COS

• EXP

• INT

• LN

• LOG

• MOD

• PI

• RAND

• ROUND

• SIN

• SQRT

Statistical
• AVG

• COUNT

• MAX

• MIN

• STD

• STDS

• SUM

• SUMPRODUCT

• VAR

• VARS

Special
• CELLNAME

• CHOOSE

• ERR

• GETCELL

• INFO

• ITEMCOUNT

• LOOKUP

• NA

• ? and ??

Group/Select

GROUPAVG

• GROUPCOUNT

• GROUPMAX

• GROUPMIN

• GROUPSTD

• GROUPSTDS

• GROUPSUM

• GROUPVAR

• GROUPVARS

• SELECT

• SELECTAVG

• SELECTCOUNT

• SELECTMAX

• SELECTMIN

• SELECTSTD

• SELECTSTDS

• SELECTSUM

• SELECTVAR

• SELECTVARS

Logical
• FALSE

• > IF

• ISEMPTY

• ISERR

• ISNA

• ISNUMBER

• ISSTRING

Valid for 1.0

Valid for 2.0

Product literature and demonstration software are available. For more information about this or any other Lighthouse Design product, send e-mail to info@lighthouse.com.