I am new to numbers and am trying to convert Australian Dollars to USD at the PayPal Rate with there fee included. Can you write the formula for me?
Thank you.
—–
Brett Kroos
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How Do I Write a Currency Conversion Formula With PayPal Fees AUD To USD?
Comments: 2 Responses to “How Do I Write a Currency Conversion Formula With PayPal Fees AUD To USD?”
Comments Closed.
I'm not sure I understand your question. If you know the conversion rate and the fee, then isn't it just a matter of multiplying and adding?
So at a rate of 0.71, you would multiply the amount by 0.71 and then add the fee. But of course the rate changes all the time, so you'd want o use the CURRENCY function to look it up.
CURRENCY("AUD","USD",0)
So if the price was in B2, and the fee was in C2, then D2 could be:
= B2 * CURRENCY("AUD","USD",0) + C2
That assumes the fee is listed in the currency you want already. Also, not sure if I have the direction of the conversion right, but you can easily reverse that.
The exchange rate PayPal uses is 0.6568. And then they charge a fee of .30
Thank you I will try out your formula.