IF Statement with Checkboxes Sum


Hi there,

I am working on a football team registration table where I record the fee and track if a deposit has been paid with one checkbox, and then another checkbox when the balance is paid off. -

I have a formula to reduce the full fee to the right amount when first checkbox is ticked. IF({Deposit Paid?} = 1, ‘£95’, ‘£195’)

I am struggling to find the IF Statement that would take into account to reduce the balance to £0 when both boxes are ticked.

Can anyone help please? Thank you :blush:


    {Deposit Paid?},
        {Remainder Paid?},

I think that should do it! :wink:


YES! That worked, thank you very much :smile: