<div>
Thanks so much for your help.
</div>


<div>
<div class="content wysiwyg-content">
Hi. I am trying to increase the total in a cell that already has a formula. The formula is pretty basic: &nbsp;=SUM(F13:F17) &nbsp;This shows the total from a column.<br />
<br />
Now I need to increase that total by 15% if another cell somewhere in the same worksheet indicates a &quot;Yes.&quot; I already have the Yes or No drop down created.<br />
<br />
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.
</div>
</div>


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.

Excel Formula...Increase total by percentage based on Yes-No validation

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.