Returning a $ value if a checkbox return true

[dellie]

Hello All,

I am trying to set up an Excel formula that calculates a $ value if a checkbox returns true or false.

Basically, if the checkbox is checked, the COST amount needs to be multiplied by the QTY value. I've attached a screen shot of the basic table.

Right now I have a basic SUM working using: =SUM(COST*QTY) but I need to include a checkbox if statement I believe. I've tried everything but can't get it to work.

Can anyone help? I'm sure it's very simple.

[DonkeyOte]

Assign the checkbox a Linked Cell, this cell will hold TRUE when checked and FALSE when unchecked... you can use this cell to control your formula.

[dellie]

Thanks. How do I do that? I'm completely new this. I'll do a search in program help too.

[DonkeyOte]

It will differ depending on what type of control has been used...

FORMS control

If you right click on the checkbox in Design Mode and can not see PROPERTIES select FORMAT CONTROL, on Control TAB you should see a box entitled "Cell Link in which you should enter the cell reference which is to hold the Boolean checked value (True/False)

ACTIVE X control

If you right click on the checkbox in Design Mode and see PROPERTIES select that and type cell reference into field entitled "Linked Cell"