# Multiple conditional formula involving checkboxes ticking to prompt addition of fields

• 0
• Question
• Updated 3 years ago

Hi,

I want to create formula to sum 5 \$ fields, however only want them to be summed when they have actually been paid. To know if it's been paid we have made a Paid checkbox.

From this I was going to make a formula to do this for us, however have got stuck.

If([Payment 1 Paid]<>ture,[Payment 1 amount]

There are 5 payment amounts and 5 Payments paid fields, how can I keep building this formula to add them all up.

Thanks

Ps. If there is better way to get the same result, suggestions welcomed.

• 0 Points

Posted 3 years ago

• 0
• 72,680 Points
Try this:

IF([Payment 1 Paid],[Payment 1 amount],0)

+

IF([Payment 2 Paid],[Payment 2 amount],0)

+

IF([Payment 3 Paid],[Payment 3 amount],0)

+

IF([Payment 4 Paid],[Payment 4 amount],0)

+

IF([Payment 5 Paid],[Payment 5 amount],0)
• 0 Points
Top Answer Mark. Can always rely on the QB Coaches to find the right solution. Thank you