Hello, I'm pretty new to excel, so sorry for stupid questions, and thanks in advance for your time.
Basically, I'm creating a spreadsheet that acts as a character sheet in a very numbers-heavy tabletop RPG. There are a number of abilities you can have which modify the numerical value of certain skill and attribute numbers. Most of these don't last for a long enough time that tracking them on the sheet is necessary, but there are some where it is helpful.
So, basically I want to create a checkbox (indicating whether an ability is active or not) that changes the value of of a cell that is already tracking the value of other cells. Take the following:
Checkbox un-checked:
A3=A1+A2
Checkbox checked:
A3=A1+A2+1
This feels like it should be relatively simple, so I'm sure I'm missing something... Anyway, thanks in advance.
Basically, I'm creating a spreadsheet that acts as a character sheet in a very numbers-heavy tabletop RPG. There are a number of abilities you can have which modify the numerical value of certain skill and attribute numbers. Most of these don't last for a long enough time that tracking them on the sheet is necessary, but there are some where it is helpful.
So, basically I want to create a checkbox (indicating whether an ability is active or not) that changes the value of of a cell that is already tracking the value of other cells. Take the following:
Checkbox un-checked:
A3=A1+A2
Checkbox checked:
A3=A1+A2+1
This feels like it should be relatively simple, so I'm sure I'm missing something... Anyway, thanks in advance.