Hi guys, I'm trying to figure what formulas needs to be used to transfer funds between different financial accounts, based on criteria entered in cells.
- transfer funds between accounts ONLY if 'R' or 'C' is selected in Transfers!F:F
- Both, Payment and Deposit values need to be triggered in a formula
(reason being because payment in 1 currency will not equal the deposit in another currency.
Say one account is GBP and another is in USD. We transfer 100 GBP and receive 120 USD -
difference disappear in currency exchange rates, no need to be recorded)
I attach the Excel file itself. Any solution to this? (ps: no macros please, wont apply here)
Shortened link to Excel file:
http://bit.ly/2tAxifi
- transfer funds between accounts ONLY if 'R' or 'C' is selected in Transfers!F:F
- Both, Payment and Deposit values need to be triggered in a formula
(reason being because payment in 1 currency will not equal the deposit in another currency.
Say one account is GBP and another is in USD. We transfer 100 GBP and receive 120 USD -
difference disappear in currency exchange rates, no need to be recorded)
I attach the Excel file itself. Any solution to this? (ps: no macros please, wont apply here)
Shortened link to Excel file:
http://bit.ly/2tAxifi
