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.