Using a checkbox to modify existing cell value

[rzrogers]

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.

 

[rzrogers]

Alright, after some continued testing, I managed to accomplish this by linking the checkbox to an unimportant cell, then using an IF function that references that cell to modify the formula... I guess my new question is: Can this be done without referencing a separate cell linked to the checkbox's TRUE/FALSE state?