troubleshooting Question

adjusting loading fees from Mastercard workbook based on value inserted

Avatar of JaseSt
JaseStFlag for United States of America asked on
Microsoft Excel
25 Comments1 Solution388 ViewsLast Modified:
gowflow has worked on this before and is familiar with the function.

For the Matercard workbook:

I need to adjust the amount of loading fees taken out (Col i and Col L) based on what is input into Col F (for the regular sheets only, not EMP, or MCR sheets). This is only for Earthport wires coming in, not Liberty Reserve,.

So here's what I need. When an Earthport wire email comes in and the function LocateEmailsToTabsNew is activated (I think that is the one) and inserts data into a row, I need the function that determines the loading fee (in Col i) to no longer be a flat fee as this calculation gives: =IF(F10*1.85%<25;F10-30;F10-(F10*1.85%)-5)

but rather I need the loading fee to adjust so that if the amount entered in Col F is less than $10,000 it is minus 2. So it would be: =IF(F10*1.85%<25;F10-30;F10-(F10*1.85%)-2)

if the amount in Col F is 10,000 or more then it is -5

So, in your calculation: =IF(F10*1.85%<25;F10-30;F10-(F10*1.85%)-5) it is only -5 when the  amount is 10,000.00 or over. Otherwise if less than 10,000 it is -2

I hope I didn't confuse
ASKER CERTIFIED SOLUTION
gowflow
Partner

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 25 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 25 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros