Forum Discussion
Creating a formula using IF
Hi. I'm new to Excel and I could really use some help. Here's what I'm trying to achieve: I use 2 merchant processors for my business: GroovePay and PayPal. When I make a sale, depending on the proce...
Let's say the sale amount is in D2 and the merchant processor in E2.
In another cell in row 2, e.g. F2:
=IF(OR(D2="",E2=""),"",IF(E2="GroovePay",D2*2.85%+1.25,D2*2.9%+0.3))
This can be filled down if required.
Perfect! Hans, you are my hero! Your formula works exact as is. It also helped me to discover my error. I was trying to add the name "PayPal" to the calculation, but since PayPal (FALSE) is not GroovePay (TRUE), I realize now that I don't need to actually add this name. Thank you again. Your assistance is most appreciated!