• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Expense Reports with FX and Form of Payment Factors

amac3434

New Member
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.
 

Attachments

  • Sample_Canada to US Expense Report.xls
    58 KB · Views: 2
Hi:

Find the attached.

Thanks
 

Attachments

  • Sample_Canada to US Expense Report.xls
    57 KB · Views: 1
Back
Top