Multiply 2 cells depending on which checkbox is checked.

Hello all,

I am trying to achieve a sum of 2 cells IF a checkbox is marked, but a different sum IF a different box is checked. For instance:

A1=TRUE(checkbox), B1*C1, OR D1=TRUE(different checkbox), B1*E1. I want this value to return a monetary number dependent on which box is checked in the same cell.

For example if I have 5 hours at $100/hr or 5 hours at $150 dependent on which box is checked.

It should be simple in my mind, but I just get a "TRUE" return from what I have tried.

Try this:

IF(A1,B1*C1,IF(D1,B1*E1,0))

Copy down as required.

Hope this helps.

Pete

Annnd that was it! Thank you so much. Way easier than I was making it.

Glad to help, and thanks for the rep.

Pete