=SUM(G9)*H9 is a typical formula that requires the input of a value - cell h9
I'd like to have a button clickable that if clicked would equal 1 and the
default would always equal 0 zero
I have a costing spreadsheet that uses a formula that times one cell and puts
it in a total cell - I'd like to incorporate a button rather than having them
have to enter a 1 in a cell. Any help would be greatly appreciated.