I need to create a yes and no button that will have multiple function depending on a cells content. For example: I have a yes and no button and in cell A1 it says you have found a gold coin, do you wish to pick it up? Yes would then add 1 coin to cell A3 and No would leave the coin in cell A1. However, if A1 were to display 2 coins I would need the yes button to calculate picking up 2 since that's how many are in the cell.
Can anyone help me with this?
Bookmarks