Nov 22 2020 11:01 AM
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!
Nov 22 2020 11:14 AM
=ROUND(IF(H3="c",5%,2%)*(F3+G3),2)