calculations using a check mark

[jdefant]

Hello, First off let me say what a great job you have done! TapForms is really easy to use. Now having said that, I can’t figure out how do make a calculation using a check mark. You allow a check mark field to be used so I hope I am just doing something wrong.

I have a number field called “gallons”

I have a check mark field called “filter”

In a calculation field called “total” I want to calculate:

Total = gallons * $5.00 PLUS $15 if “filter” has been checked.

Any ideas?

Thanks

Chris

[Brendan]

Hello Chris,

You could just multiply your formula by the check mark field so that the result will be 0 if not checked and will be the regular value if checked.

Thanks!

Brendan

[jdefant]

Yes! The check mark field has a value of 0 if not checked and a value of 1 if checked!

Thanks

[Author]

Posts