Introduction
Kepion supports a large number of Excel Functions in our Forms, allowing for the creation of more dynamic and customized content. For example, you can create custom sub-totals in a Form that has a dynamically changing number of rows.
Example
1. Click Edit.
2. Right-click a row header and select either Insert Before or Insert After to create your new static row.
3. In the newly created row you can now enter a spreadsheet formula such as:
=sum(D:G)
This formula directs the spreadsheet to add up the values in the column range (e.g. D to G) and display the sum in the selected cell.
Tip: Static rows are indicated by the * preceding the header label.
Excel Functions
For more details, you can find the full list of Excel functions which are supported in Kepion below:
Function | Example |
---|---|
SUM | =SUM(A1:A2) |
AVERAGE | =AVERAGE(1; 2; 3) |
AND | =AND(A1; A2) |
OR | =OR(A1; A2) |
NOT | =NOT(A1) |
IF | =IF(A1; TRUE; FALSE) |
ISNA | =ISNA(A1) |
ISERR | =ISERR(A1) |
ISERROR | =ISERROR(A1) |
ISNUMBER | =ISNUMBER(A1) |
VLOOKUP | See Excel online documentation |
HLOOKUP | See Excel online documentation |