Vous êtes ici: Help Topics > Customization > Cells > Supported Excel Functions

Supported Excel Functions

The following table outlines the formulas that can be pasted from Excel into CaseView.

Excel Function CaseView Equivalent Description
- - When converted into CaseView, negations are always surrounded by a pair of parentheses. -3/-3 in Excel is converted into CaseView as (-3)/(-3).
+, -, *, / +, -, *, / Standard arithmetic operator.
% Division by 100 When CaseView converts percentages from Excel it will append /100 to the formula or try to divide the value by 100.
& + In Excel, the ampersand (&) connects, or concatenates two values to produce one continuous text value while CaseView uses the plus symbol.
LOG(num), LOG10(num) LOG(num)
LOG (num, base) LOG(num)/LOG(base) CaseView's LOG function does not take a base parameter, but LOG functions from Excel are converted using the LOG identity.
SUM SUM

Excel's SUM function can take multiple arguments, accept range, cell reference and numbers as its arguments while CaseView's SUM can only take a range. SUM can be converted with the help of the plus sign "+" operator.

Examples

  • In Excel: SUM(A1:B2) converts into CaseView: SUM(A1..B2).
  • In Excel: SUM(A1) converts into CaseView: (A1).
  • In Excel: SUM(A1:B2, 3, F4) converts into CaseView: (SUM(A1..B2) + 3 + F4).
PRODUCT *

CaseView has no function for multiplication, so the PRODUCT function is converted by using the multiplication operator (*).

Examples

  • In Excel: PRODUCT(A1:B2) converts into CaseView: (A1 * B1 * A2 * B2).
  • In Excel: PRODUCT(A1, B3) converts into CaseView: (A1 * B3).
NOT ~ In Excel: NOT(A1) converts into CaseView: (A1).
AND & In Excel: AND(A1:A3) converts into CaseView: (A1 & A2 & A3).
OR | In Excel: OR(A1, A2) converts into CaseView: (A1 | A2).
CONCATENATE +

The CONCATENATE function is treated in the same way as the "&" operator.

In Excel: CONCATENATE(A1, B1) converts into CaseView: (A1+B1).

MIN MIN

Excel's MIN function can take a range of cells while CaseView's MIN function cannot. A range will be split when converted to CaseView.

In Excel: MIN(A1:B2, 5) converts into CaseView: MIN(A1, B1, A2, B2, 5).

Excel also allows single values passed into the function, but doing so in CaseView will result in error. Since the MAX of a single value is just the value itself, it is translated to CaseView as such.

In Excel: MIN(A1) converts into CaseView: (A1).

MAX MAX

Excel's MAX function can take a range of cells while CaseView's MAX function cannot. A range will be split when converted to CaseView.

In Excel: MAX(A1:B2, 5) converts into CaseView: MAX(A1, B1, A2, B2, 5).

Excel also allows single values passed into the function, but doing so in CaseView will result in error. Since the MAX of a single value is just the value itself, it is translated to CaseView as such.

In Excel: MAX(A1) converts into CaseView: (A1)

PROPER(text) TITLE(text, 1)

This function is not converted identically.

In Excel: PROPER(text) capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.

In CaseView: TITLE(text, 1) means that letters following after a character that is not a letter, number, or single quote will be capitalized.

Examples

  • PROPER("76Budget") returns "76Budget" while TITLE("76BudGet") returns "76budget".
  • PROPER("this is a TITLE") and TITLE("this is a TITLE", 1) returns This Is A Title.
  • MEDIAN(A1:B2)
  • AVERAGE(A1:B2)
  • STDEV(A1:B2)
  • MEDIAN(A1..B2)
  • AVERAGE(A1..B2)
  • STDDEV(A1..B2)

The MEDIAN, AVERAGE, and STDDEV functions in CaseView only allow a range of cells. If the Excel formula contains more than one arguments or the argument is not in range, the formula is not converted.

For example the following formulas will not be converted in CaseView:

MEDIAN(1, 2, 3), AVERAGE(A1, C3)

IF IIF

Excel allows empty arguments in the IF Function which is not supported in CaseView.

In Excel: IF(A1, B1) and IF(A1, TRUE,) are allowed, but formulas similar to this cannot be converted into CaseView.

CHOOSE CHOOSE
ABS ABS
MOD MOD
LEFT LEFT
RIGHT RIGHT
MID MID
CHAR CHR
TRIM TRIM
UPPER UPPER
LOWER LOWER
CODE ASC
LEN LENGTH
^ EXP
POWER EXP

Notes

  • An empty cell is pasted in CaseView as a 0-valued numeric cell. This may affect calculations such as AVERAGE, MEDIAN, etc because empty cells are ignored in Excel's calculation.
  • When an Excel formula cannot be converted to a CaseView formula, the value of the cell is pasted instead. No warning will be displayed about any non-convertible formulas.
  • A combination of the supported functions may not be supported. For example, =SUM(IF(TRUE, A1, B1):IF(FALSE, D1, C1)) is a valid Excel formula that sums the value from A1 to C1, but this cannot be translated to a CaseView formula even though SUM and IF are supported. In Excel, the colon is a range operator so A1:C1 means the cells between A1 and C1 inclusively. In CaseView...