Calculating an or statement

%3CLINGO-SUB%20id%3D%22lingo-sub-1921977%22%20slang%3D%22en-US%22%3ECalculating%20an%20or%20statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1921977%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20calculate%202%20different%20percentage%20charges%20for%20sales.%20%26nbsp%3BIf%20the%20purchase%20is%20made%20by%20credit%20card%2C%20the%20percentage%20taken%20should%20be%205%25%2C%20but%20if%20the%20purchase%20is%20made%20by%20a%20debit%20card%2C%20the%20percentage%20taken%20should%20be%202%25.%20%26nbsp%3BI%20have%20the%20formula%20for%20the%20credit%20card%26nbsp%3B%3DROUND(IF(H3%3D%22c%22%2C(F3%2BG3)*0.05%2C0)%2C2).%20%26nbsp%3BI%20need%20to%20know%20how%20to%20add%20the%20debit%20card%20percentage%20using%20%22d%22%20to%20the%20same%20formula.%20%26nbsp%3BAny%20suggestions%3F%20%26nbsp%3BThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1921977%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1921995%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20an%20or%20statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1921995%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F878018%22%20target%3D%22_blank%22%3E%40smsimo0856%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DROUND(IF(H3%3D%22c%22%2C5%25%2C2%25)*(F3%2BG3)%2C2)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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)