Check box condition

[marinpa]

Hello everyone,

Can someone help me with this?
How do I condition column C based on the checkbox on column B?

Column A_____________Column B___________Column C
_Amount_____________checkbox_______________n%

Cells from column C should reflect 15-20% from corresponding cells on column A

If a checkbox on B is checked, corespondent cell on column C remains blank

Thank you!

 

[nemmi69]

I assume this is without VBa

1) in the [FONT=&quot] [/FONT]ActiveX Control checkbox property, Linkedcell pick a cell that will be the response of the checkbox say "D2"
2)in the appropriate cell, I assume C enter something like =IF(D2=True,"",your formula here)

does that make sense?

 

[marinpa]

Yes, no VBA

Unfortunately unable to make it work.

Can you be more specific? Thanks

 

[nemmi69]

The ActiveX Control checkbox will have one of it's properties called Linkedcell. This is the cell that will indicate True if checkbox is check.
Since the checkbox can sit over the cell I guess in your case it would be in "B"
So for row A2 checkbox would refer to linked cell B2. the formula in C2 would be =IF(B2=True,"",A2*(20/100))

Any clearer?

 

[marinpa]

Yes, Thank you so much!