calculating tick boxes

New Contributor

I’m trying to create a commission calculation spreadsheet, before I go any further can anyone please help by advising if there is a way of creating a formula that would add amounts if tick boxed are used?

Fitzsuzy_1-1641325736929.png

 

Kind regards

2 Replies

@Fitzsuzy I believe you already worked out that you can link a cell to a checkbox. Not checked, the cell will contain FALSE (=0). When checked, the cell will contain TRUE (=1). The screenshots below demonstrates how you can calculate with these.

Screenshot 2022-01-05 at 08.42.03.png

Screenshot 2022-01-05 at 08.38.45.png

this is Amazing @Riny_van_Eekelen, thank you so much for taking the time to help me with this