Return to Contents

Invrea's Scenarios plugin generates possible scenarios in a process that runs alongside Excel called its inference engine. This means that Excel functions need to be duplicated in Scenarios' inference engine so that Scenarios can use them quickly. The Excel functions that have been reimplemented in this way - well over 100 of them - are listed below. Note that Scenarios can also call Excel functions that are not implemented, along with user-defined functions or macros written in Visual Basic. However, including these will cause scenario generation to be substantially slower; if possible, stick to using the functions listed below.

If you have a function you'd particularly like us to speed up and add to this list, whether or not it's a default function in Excel, contact us here.

On this page

  1. Date and Time Functions
  2. Engineering Functions
  3. Financial Functions
  4. Information Functions
  5. Logical Functions
  6. Lookup and Reference Functions
  7. Math and Trigonometry Functions
  8. Statistical Functions
  9. String and Text Functions

Date and Time Functions

(↩)
  1. DATE
  2. DAY
  3. HOUR
  4. NOW
  5. MINUTE
  6. MONTH
  7. SECOND
  8. TIME
  9. WORKDAY
  10. WEEKNUM
  11. YEAR

Engineering Functions

(↩)
  1. BITAND
  2. BITOR
  3. BITXOR
  4. DELTA
  5. GESTEP

Financial Functions

(↩)
  1. DB
  2. EFFECT
  3. FV
  4. IRR
  5. NOMINAL
  6. NPER
  7. NPV
  8. PMT
  9. PV
  10. RRI

Information Functions

(↩)
  1. ISBLANK
  2. ISERR
  3. ISERROR
  4. ISEVEN
  5. ISLOGICAL
  6. ISNA
  7. ISNONTEXT
  8. ISNUMBER
  9. ISODD
  10. ISTEXT
  11. N
  12. NA
  13. TYPE

Logical Functions

(↩)
  1. AND
  2. FALSE
  3. IF
  4. IFERROR
  5. IFNA
  6. IFS
  7. NOT
  8. OR
  9. SWITCH
  10. TRUE
  11. XOR

Lookup and Reference Functions

(↩)
  1. CHOOSE
  2. COLUMNS
  3. HLOOKUP
  4. INDEX1
  5. LOOKUP
  6. MATCH
  7. ROWS
  8. TRANSPOSE
  9. VLOOKUP

Math and Trigonometry Functions

(↩)
  1. ABS
  2. ACOS
  3. ACOSH
  4. ACOT
  5. ACOTH
  6. ASIN
  7. ASINH
  8. ATAN
  9. ATAH2
  10. ATANH
  11. CSC
  12. CSCH
  13. CEILING
  14. COS
  15. COSH
  16. COT
  17. COTH
  18. DEGREES
  19. EXP
  20. FACT
  21. FACTDOUBLE
  22. FLOOR
  23. GCD
  24. INT
  25. LCM
  26. LOG
  27. LOG10
  28. LN
  29. MDETERM
  30. MINVERSE
  31. MMULT
  32. MUNIT
  33. MOD
  34. PI
  35. POWER
  36. PRODUCT
  37. QUOTIENT
  38. RADIANS
  39. RAND2
  40. RANDBETWEEN2
  41. ROUND
  42. SEC
  43. SECH
  44. SIGN
  45. SIN
  46. SINH
  47. SQRT
  48. SQRTPI
  49. SUM
  50. SUMIF
  51. SUMPRODUCT
  52. SUMSQ
  53. SUMX2MY2
  54. SUMX2PY2
  55. SUMXMY2
  56. TAN
  57. TANH

Statistical Functions

(↩)
  1. AVERAGE
  2. CORREL
  3. COUNT
  4. COUNTA
  5. COUNTBLANK
  6. COUNTIF
  7. GAMMA
  8. GAMMALN
  9. LINEST3
  10. MAX
  11. MEDIAN
  12. MIN
  13. MODE
  14. STDEV

String and Text Functions

(↩)
  1. CONCAT
  2. CONCATENATE
  3. EXACT
  4. FIND
  5. LEFT
  6. LEN
  7. LOWER
  8. MID
  9. PROPER
  10. REPLACE
  11. REPT
  12. RIGHT
  13. SEARCH
  14. T
  15. UPPER

1. INDEX, in Scenarios, is only allowed to take three arguments: a range, a row number, and a column number. The optional fourth argument, an area number, is not supported in Scenarios. (↩)

2. These primitives are wrapped as standard distributions in Scenarios, thereby making them suitable for use in ACTUAL statements as well. However, this makes them unsuitable for some features of Scenarios, such as locking and seeding. (↩)

3. Only supported when there is only one dependent variable Y (i.e. input is a row or column range). (↩)