Microsoft KB Archive/34158

From BetaArchive Wiki

Functions Supported in Multiplan Version 2.x PSS ID Number: Q34158 Article last modified on 09-15-1988 PSS database name: D_MPlan




The following list contains the functions supported in Multiplan Version 2.x:

Function Result

ABS(number) Absolute value of number AND(list) True if all logical values in list are True; otherwise False ATAN(number) Arctangent of number AVERAGE(list) Average of numbers in list COLUMN() Column number of cell COS(number) Cosine of number COUNT(list) Count of numbers in list DELTA() Maximum change in valses between interaction DOLLAR(number,decimal) Round number to decimals and converts to text in currency format EXP(number) The value e to the power number FALSE() Logical valses False FIXED(number,digits) Rounds number and converts to text in fixed format FV(rate,nper,pmt,pv,time-of-pmt) Future value of investment IF(logical,value-if-true,value-if-false) Value-if-true if logical is TRUE; values-if-false if logical is FALSE INDEX(range,row,column) Cell contents for the specified row and column in range INT(number) Integer par of number IRR(list,guess) Returns internal rate of return of list ISERROR(item) True if item is any error item ISNA(item) True if item is the error item #N/A ITERCNT() Current iteration count LEN(text) Length of text LN((number) Natural logarithm to the base e of number LOG10(number) Logarithm to the base 10 of number LOOKUP(item,table) Entry in table specified by item MAX(list) Maximum number in list MID(text,start,#-characters) Extracts #-characters from text MIN(list) Minimum number in list MIRR(list,safe,risk) Modified internal rate of return of list MOD(number,divisor) Remainder of number divided by divisor NA() Error value #N/A NOT(logical) True if logical is False: False if logical is True NPER(rate,pmt,pv,fv,time-of-pmt) Number of payments of investment NPV(rate,list) Net present value of list OR(list) True if any value in list is True; otherwise, False PI() The value pi to 13 decimal places PMT(rate,nper,pmt,fv,time-of-pmt) Periodic payment of investment PV(rate,nper,pmt,fv,time-of-pmt) Present value of investment RATE(nper,pmt,pv,fv,time-of-pmt,guess) Rate returned on investment REPT(text,count) Repeats text number-of-times ROUND(number,decimals) Number rounded to decimals ROW() Row number cell SIGN(number) Sign of number SIN(number) Sin of number SQRT(number) Sine of number STDEV(list) Standard deviation of numbers in list SUM(list) Sum of numbers TAN(number) Tangent of number TRUE() Logical value TRUE VALUE(text) Converts text to a number

Copyright Microsoft Corporation 1988.