Calculating multiple currencies against Different Rate Types, into USD.
I have a set of columns, "Rate" "Rate Type" and "Adjstd Rate (USD)". Rate is a numerical value, formatted to specific currency. Rate Type indicates whether the rate is a Daily Rate (Made up of 8 hours), an Hourly Rate. The following are some examples outlining what I am looking to achieve with (maybe w/ sumifs?)
EG: £800.00, Day Rate is $134.00 @ hr. This is achieved by simply multiplying the rate by 1.3(standardized conversion from GBP to USD) then dividing by 8.
EG2: €800.00 Day Rate * 1.1 /8 = $110.00
EG3: £32.00 Hourly $41.60
Is there a way for a formula to recognize the currency, and apply conversion (1.3 and 1.1 respectively) and then depending on the Rate Type, divide by 8 or not?
Can it be a column formula?
Best Answer
-
Can you add a helper column? Add a dropdown column for currency, select which currency, and depending on that, create a IF formula.
Will this work?
Answers
-
Can you add a helper column? Add a dropdown column for currency, select which currency, and depending on that, create a IF formula.
Will this work?
-
That If statement is a thing of beauty. Thank you.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives