How to set a condition to a false checkbox

Question

Level 1

4 points

How to set a condition to a false checkbox

I’m currently doing a wedding costs spreadsheet and have successfully managed to figure out how to make a “true” checkbox deduct deposit paid from a balance, however i am now struggling to make a “true” checkbox for balance paid revert the balance to 0. I therefore added a 3rd column called “still to pay” to try and make this easier and now that successfully reads 0 when the box is checked, however when the box is unchecked it states FALSE. How do i work around this? I would want when unchecked it to display the “balance left to pay” figure as i of course would have the sum of “still to pay” displayed as outstanding wedding costs! Hope this makes sense.

The following screenshots are:

1) a successful ticked box which reads 0

2) an unchecked box which reads FALSE

PLEASE HELP

iPad Air, iPadOS 14

Posted on Jul 22, 2022 7:44 AM

Reply

Answer 1

SGIII

Level 8

37,550 points

Jul 22, 2022 8:57 AM in response to rhianna2103

The IF statement has a structure like this:

So I'm guessing you need something like this:

=IF(Balance Paid Hall,0,Total Cost Hall-Deposit Amount Hall)

SG

Reply

Answer 2

Barry

Level 9

60,023 points

Jul 22, 2022 1:46 PM in response to rhianna2103

This would be my approach:

The formula on the left is entered in cell E2 (Balance to Pay).

This formula gets the amount in cell B2 (Total amount) then subtracts the deposit amount IF the deposit has been paid.

The second formula is the same as the first, but gets the Balance due from column E, then subtracts that amount if the Balance paid box is checked.

Regards,

Barry

PS: As constructed, your table does not account for partial payments of the balance owing on each line. Is that a possible occurrence?

Reply