If checkbox is checked, then the formula is applied.

vm1234 -  
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   -
Hello,

How do I insert a checkbox in Excel to determine if a formula is applicable or not?

More specifically, if the checkbox is checked, meaning the condition is met, then I want to display 12% of the content of a given cell.

Otherwise, I want the cell to remain empty.

Also, how do I activate macro creation in my file? I am working with Excel 2007.

Thank you

Configuration: Windows / Chrome 60.0.3112.101

2 réponses

vm1234
 
Great. It works perfectly.

Thank you
0
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   17 474
 
That's good.

And if you are considering asking more questions about CCM, you will feel more comfortable by registering as a member (free, immediate, without commitment, and with many additional options...)
0