Check boxes linking different formulas to one Cell

[Sleepingsouls]

Hi Guys,

I'm running an accounting spreadsheet and what I want to do is have one cell lets call it A1 display a different result based on a different formula depending on what Checkbox is ticked

For example if "Reinvest" checkbox is ticked it does sum(C1+B1) if "Take" checkbox is checked it does B1-D1 and if "Loan" Check box is ticked it will do a different formula lets call it Sum(D1:D3) and lastly if none of them are checked it would display no value.

Thank you for your help

 

[Yongle]

Link checkboxes "Reinvest" "Loan" "Sum" to cells "B3" "B4" "B5" respectively

and formula
=IF(B3+B4+B5>1,"Choose one box",IF(B3=TRUE,C1+B1,IF(B4=TRUE,B2-B1,IF(B5=TRUE,SUM(D1:D3),""))))

 

[Sleepingsouls]

Thank you,

Unfortunately I am coming across the same problem I was having when trying to create a macro for this. Once the first check box has been checked when I uncheck it the formula does not go away and then clicking on the next checkbox doesn't produce the right number. The only way to get the right number is to click the check boxes in a specific order.

 

[Yongle]

It works perfectly for me
- if there is more than one box ticked "Choose one box" is returned otherwise the correct result is returned
- cells B3 B4 B5 contain TRUE if checked FALSE otherwise

Which type of checkbox are you using?

 

[Sleepingsouls]

That's what I thought was supposed to happen, just didn't seem to be the case for me with this formula or my macro.

Just the standard check box not the activeX

 

[Sleepingsouls]

Interestingly enough - I was using different cells for my forumla all I have done is change the Cells... and that didn't work so to test it I changed my cells to the ones in your formula and that worked... Strange

 

[Yongle]

Do not fret about the mystery - just be grateful you got it working