Excel Functions in Forms

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: