How to use a Check box Tick in a formula

[Obwan]

Hello, appreciate help with this.
In column A there is a check box (Tick or blank). Column B has a value, Column C has a percentage. In column D I want to create a formula to say: if A1 = Yes (tick symbol) then B (Price) less C (discount), else Blank. In the Formula how do I write "If A1 is ticked" Thank you.

[FloMM2]

Obwan,
If you don't want to get into programming in VBA. You could change Column A from a CheckBox to an "X".
Your formula in Column D would look like this:
"=IF(A1="X",(B1*C1),"")" without the first or last ".
What this does is look for an X in Column A, if it has an X, then it multiplies the discount in Column C by Cost in Column B. This gives the discount amaount.

hth