I need to figure out how to make my sheet work based on conditions. In the example I've attached I need help with the following:
1. Add a button to be clicked that if $G$2=true, then $C$5=$C$4*2
2. Add a button to $F$5 and another to $F$6. Then if $F$5=true, both of my formulas calculate as they're written already.

Then I need the condition... If the button in $B$5= TRUE, then $F$5 MUST be False.

In simple terms, if we have a customer who chooses a 2 year contract they are unable to use monthly payments and hence that set of boxes must remain "N/A".

Is it possible to create a pop-up to state this that if the button in $B$5 is clicked and someone attempts to click on yes for monthly payments to state this can't be done?

Last question- should I use form or activex controls?

I also want to mention that I'm very much a novice and have never dabbled in VBA code- so please dummy it down to help ensure I "get it". I'm using excel 2013.

Example.xlsx