Calculating an or statement

Copper Contributor

I need to calculate 2 different percentage charges for sales.  If the purchase is made by credit card, the percentage taken should be 5%, but if the purchase is made by a debit card, the percentage taken should be 2%.  I have the formula for the credit card =ROUND(IF(H3="c",(F3+G3)*0.05,0),2).  I need to know how to add the debit card percentage using "d" to the same formula.  Any suggestions?  Thank you!

1 Reply

@smsimo0856 

=ROUND(IF(H3="c",5%,2%)*(F3+G3),2)