Need Help with Simple Formula

[bamaisgreat]

I have a simple spreadsheet that I use to keep up with sales. I have C4 that has price sold for and D4 that shows the 9% sales tax. I have a total at the end that simply adds them together and shows the total. I have recently added 2 columns for Credit Card charges 1 that figures 3% of the total sale and one that has payment method which has a dropdown that says Credit Card, Debit Card and Cash. I need the formula to look into F4 and if it says Credit Card add the amount in E4 to the total. If it says Debit or Cash do nothing else. Make Since?
This is an Example.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>

Price Marked	Sold For	Tax 9%	CC 3%	Way of Pay	Total
Credit Card

<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"><col width="100"><col width="100"></colgroup><tbody>
[TD="align: right"]350.00[/TD]
[TD="align: right"]325.00[/TD]
[TD="align: right"]29.25[/TD]
[TD="align: right"]45.00[/TD]

[TD="bgcolor: #ff9900, align: right"]354.25[/TD]

</tbody>

 

[Michael M]

Have a look at your duplicate thread

https://www.mrexcel.com/forum/excel-questions/986683-need-help-formula.html

 

[Joe4]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you not to bump a thread more than once a day.