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