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.