{"id":12575,"date":"2023-01-19T10:19:33","date_gmt":"2023-01-19T01:19:33","guid":{"rendered":"https:\/\/www.eformsign.com\/en\/blog\/?p=12575"},"modified":"2023-01-19T10:19:35","modified_gmt":"2023-01-19T01:19:35","slug":"how-to-use-excel-formulas-and-functions-to-automatically-fill-out-fields-in-a-form","status":"publish","type":"post","link":"https:\/\/www.eformsign.com\/en\/blog\/how-to-use-excel-formulas-and-functions-to-automatically-fill-out-fields-in-a-form\/","title":{"rendered":"How to Use Excel Formulas and Functions to Automatically Fill Out Fields in a Form"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

Excel formulas and functions play a vital role in data management and analysis in any department\/team of any organization for they can simplify complex calculations, get work done faster, and automate repetitive tasks.<\/p>\n\n\n\n

Wouldn’t it be great if you could apply Excel formulas and functions to your e-documents?<\/p>\n\n\n\n

Well, with eformsign you can! It is the only e-document solution in the industry that supports Excel functions and formulas.<\/p>\n\n\n\n

All you need to do is use the eformsign Microsoft Add-in to create an e-document, apply Excel formulas\/functions, and then upload the form.<\/p>\n\n\n\n

In this blog, we’ll go over a simple example on how to apply a Excel formula to an e-document. In this example, we’ll apply a simple formula where you get the sum (Total Fee) of two values (Member Fee, Card Fee).<\/p>\n\n\n\n

Instructions:<\/strong><\/h2>\n\n\n\n

1. Download and install<\/a> the eformsign Microsoft Office Add-in. <\/span><\/p>\n\n\n\n

2. Create a form and add fields.<\/span><\/p>\n\n\n\n

3. Click on a cell where you want the formula to go and assign it an ID (Total Fee). <\/span> <\/p>\n\n\n\n