Hi. I am trying to increase the total in a cell that already has a formula. The formula is pretty basic: =SUM(F13:F17) This shows the total from a column.
Now I need to increase that total by 15% if another cell somewhere in the same worksheet indicates a "Yes." I already have the Yes or No drop down created.
I need a formula that works to do that. I think it is pretty basic, but I can;t seem to fit my mind around it this morning. Any help would be appreciated.