If you are creating a calculator and have already performed calculations in Excel, there are two ways to transfer the formula onto our platform. You can either directly enter the Excel formula into our formula builder or upload the Excel file and follow the steps provided below.
Use Excel-based Table
When you're in the formula builder, click on "Use Excel Based Table" to upload your Excel. Then click "Upload Excel" to find your file.
After uploading your Excel file, you will need to map the cells in your Excel sheet with the corresponding question numbers of the calculator that you are creating. For instance, if cell B2 corresponds to question number 1, you should insert =Q_1 in that particular cell. Repeat this process for all the questions that are used in the final result formula.
Note: Any cell that needs to reference a question should be of the format =Q_1 for question 1, and any cell that references a cell (for fixed values) can just be =A1+B1.
Map the Result
After mapping all the questions in Excel, you need to map the cell number for the result in the space provided. In this case, cell B4 calculates Result 1.
After mapping all the required cells with the questions and results of the quiz, click on the 'apply Excel formula' button located on the bottom right of your screen and then exit. If you have multiple results to display, you must repeat this process separately for each one.
If you want to use an if-else condition in Excel, you can use the format: IF (condition, true, false). For example, if you want to set a condition that if B3 is greater than B2, then multiply Q1 by 10, otherwise just use Q1, you can use this formula in Excel: IF(B3>B2,Q_1*10,Q_1)
Similarly, to use the same condition in the formula builder, where B2 and B3 represent questions 2 and 3 respectively, you can use the following formula: Q3>Q2?Q1*10:Q1
Nested IF:
If you have multiple IF-ELSE conditions, you can use the following format -
IF(condition,true,(IF(condition,true,IF(condition,true,false))))
For example, If question 1 is equal to 0, then it should be one if question 1 is greater than or equal to 2, then Q1*10 else 1.
IF(Q_1==0,0,(IF(Q1>=2,Q_1*10,1)))
For inserting nested IF conditions in the builder directly, you can refer to more details on this link.
If you still have questions, feel free to use our chat widget on the bottom right to get in touch with our Excel and maths experts :)