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 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.