Skip to main content

IF Statement with Checkboxes Sum

  • June 9, 2018
  • 2 replies
  • 36 views
Y

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:

    2 replies

    W
    Forum|alt.badge.img+5
    • W_Vann_Hall
    • Inspiring
    • June 9, 2018
    IF(
    {Deposit Paid?},
    IF(
        {Remainder Paid?},
        '£0',
        '£95'
        ),
    '£195'
    )

    I think that should do it! :winking_face:

      Y
      • Yasemin_Ercan
      • Author
      • New Participant
      • June 10, 2018

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

      Terms & ConditionsAccessibility statement