Add a number from a box if I put "y" in another box

[Brad.Katronis]

Hello, I'm working on a commission sheet to calculate commissions. What I'm trying to do is the following:

I want to display a number in a box which is derived from another box, and then add the amount from another amount only if I type "y" in a box. Or if there is anyway to have this function complete.


Basically I take an initial draw before I sign a contract and then I take a final draw when the contract completes. Sometimes the contract doesn't complete so I want the box to only add the final draw if I select I put "y" (for yes) in the box.

Any feedback would be greatly appreciated!!!

[rathamus1]

=IF(A3="Y",SUM(A1,A2),A1)

A3 would be the box that would or would not have "y". A1 is your initial draw and A2 is your final draw. Hope this helps.