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>

 

[ryanLhne]

=IF(F4="Credit Card", SUM(C4,D4,E4), SUM(C4,D4))

 

[kgartin]

=C4+D4+if(F4="Credit Card",E4,0)

 

[Joe4]

=IF(F4="Credit Card", SUM(C4,D4,E4), SUM(C4,D4))

Note that SUM(C4,D4,E4) can simply be written as SUM(C4:E4)

 

[bamaisgreat]

Thanks for all the help. Could i possibly add a formula in E4 that if F4 doesnt say Credit Card then the sum of this formula(=(C4+D4)*3%) will be 0

 

[ryanLhne]

=IF(F4<>"Credit Card",0,.03*sum(c4,d4)) should do it if I understand you correctly.

 

[cnauta]

I think this may help out:

In column E which is the Tax 9% field I simply put a formula of: =D4*.09

In column F which is the CC 3% field I simply put a formula of: =IF(G4="Credit Card",D4*0.03,0)

In column G which is the Way of Pay column I simply put a validation drop box list containing either "Cash", "Debit", or "Credit Card" (if you need help in creating a drop down list for this column you can look here): How to add a drop-down list to an Excel cell - TechRepublic

Then finally in column H which is called the Total field I simply put this formula: =IF(G4="Credit Card",D4+E4+F4,D4+E4)

Then I simply copied all the cells in columns E, F, and H down to fill with the same formula. I have tested this out on various examples with cash, or debit in the Way of Pay field and it doesn't calculate the 3% CC fee, it only calculates it when you select Credit Card from the drop down list in column G.


Cheers!<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>

 

[bamaisgreat]

Thanks you all

 

[bamaisgreat]

On more question. I have the following in D4 =C4*9% I need this to be if F4 has "Cash WPT" in it that the value is 0

 

[bamaisgreat]

If the drop down says "Cash WPT" I need the tax cell to be 0. So in other word no tax if CASH WPT is payment method.