Checkbox IF Functions

I am trying to calculate checkboxes in my excel worksheet and am really having a hard time in doing so. - I am usually pretty good at formulas but this one is causing me to drink as it is probably something pretty simple that I have forgotten to do.

Here is my dilemma:

Equipment Rentals.xls

I am trying to calculate that if cell C4 is checked then it will calculate cell a4*d4 (cost of equipment x number of days), or if cell E4 is checked it will calculate cell F4 *A4 and if cell G4 is check it will calculate cell H4*A4. - the totals will be calculated in cell I4 depending on what check box is checked.

When I write the formula as
=IF(C4=TRUE,A4*D4,IF(E4=TRUE,A4*F4, IF(G4=TRUE,A4*H4,0)))

Please help me!!!

Checkboxes need to be linked to a cell for formulaic referencing. If you go into Design Mode and then click on the PROPERTIES of the checkbox, there is a LinkedCell option there. I linked your three boxes to the cells underneath them, and painted the font white so the TRUE responses won't show.

Then I set your formula to:

=((C4*D4)+(E4*F4)+(G4*H4))*A4

The problem I foresee is that looks like the beginning of a long list. I see you manually creating a LOT of checkboxes and linking them to cells.

It's just as useful to leave out the checkboxes and put a reference IN the cell itself, like an X and use a slightly different formula

=((ISTEXT(C7)*D7)+(ISTEXT(E7)*F7)+(ISTEXT(G7)*H7))*A7

easier to use option buttons from the forms toolbar inside a group box
link to a cell I used k4 then stick formula in totals

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]