Require a similar Form Calculation in my form

Hi Guys!

I would like to create a form that can use the calculation below based on this table:

This would be the formula:

((Budget * Related %)/ Cost Per Lead)* (Time Frame) = total leads generated

Example:

Selected Time Frame: 6 months 

Monthly Budget Set: $1,550

Cost Per Lead: $9

Calculation:

(($1,550 * 40%) / $9)*(6)= 413 total leads generated

please advise, thank you!

Roger

Based on your requirement, you can add an Input table and related fields as shown below.

Unfortunately, we cannot show the value inside the Input table, but you can assign value to each cell.

Then calculate values as shown below.

Here's a screencast on how I did the calculation:

Here is my demo form: https://form.jotform.com/92164500739962

You can clone it if required - https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

Hope this helps.

The only thing is, I need to have it where the client doesn't have to select anything in the table matrix.

IE:

Is it possible to have a condition, that if they select a term, and then enter an amount - that the form can make the selection for them in the background - in order to complete the calculation?

Also, thank you very much for your help!

This is the form I've started:
https://form.jotform.com/92164736272965

You would need to perform the calculations based on conditions, assuming that the cost per lead is a fixed price($9), I have created these conditions on this demo form: https://form.jotform.com/92165055659969

((budget * percentage)/9)*months

First set:

Second set:

Third set:

Result:

You may clone my form to check it further: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

Let us know if you need more help.