I'm trying to get some help with "what" type of formula i should be considering for the following challenge. I am trying to create an expense report template for Canadians that come to the US. There are daily currency rates as well as form of payment (CC, Debit, Cash) impacts to the calculation.
So the "english" version of what I'm trying to do is:
US dollar (c2) on expense listing multiplied by the "form of payment" conversion rate on the exchange rate tab for the specific Date.
I'm willing to learn from the blog - and trial and error - but don't know what type of formula to work from. Any hints are appreciated.
So the "english" version of what I'm trying to do is:
US dollar (c2) on expense listing multiplied by the "form of payment" conversion rate on the exchange rate tab for the specific Date.
I'm willing to learn from the blog - and trial and error - but don't know what type of formula to work from. Any hints are appreciated.