If checkbox is checked, display a number

Hello!


I'm looking to format some cells, but I don't know if it can be done.


For every box that is checked in B-D, I want 'total' to add 25. IF box E is filled, I want it to remove 25.


For example, if B and C is checked, show '50'. If B, C and D are checked, show '75'. HOWEVER, if B and E are checked, it would show 0.


I'm happy if I have to separate it out, for example have a total and then a second box saying if x is checked, display total-25.


Does anybody have any idea how to do this please?


MacBook Air 13″, macOS 14.2

Posted on Jun 26, 2024 1:39 PM

Reply
Question marked as Top-ranking reply

Posted on Jun 26, 2024 3:16 PM

=25×COUNTIF(B2:D2,TRUE)−IF(E2,25,0)


If E2 is the only one checked, the result will be -25. Is this the correct result?

2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

If checkbox is checked, display a number

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.