Hi,
I've many expenses for several projects and I've made dash board to track the revenue and expenses for all the project, the issue is some of the project has many different currencies which cause to compute all rates as they're the same and I'm reverting the data using SUMIF function, i want to know if there is any function that can check the column that shows the currency and multiply it by factor based on the rate that i will assign.
Bookmarks