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

cwaite3 used Ask the Experts™
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.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
using d2 as an example:

=SUM(F13:F17) * IF(d2="Yes",1.15,1)


Thanks so much for your help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial