If checkbox is checked, then the formula is applied.

vm1234 -  
Raymond PENTIER Posted messages 58213 Registration date   Status Contributor 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 answers

  1. vm1234
     
    Great. It works perfectly.

    Thank you
    0
    1. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
       
      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