Ajwilltravel
New member
- Joined
- May 2, 2017
- Messages
- 22
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- MS Office Prof Plus 2013
View attachment Formula.xlsx
Hi there
Hoping a formula wiz can help me with this… please refer attached excel sheet.
In the highlighted cells I need to input formulas to covert values below to USD – so convert the values in column D, rows 19 to 63 (which are in source currency), by the highlighted rates for each currency in column D rows 66 to 73 – the common link being the text in column B – so convert each source currency value to USD and sum those converted values by the text (in column B) – e.g. convert to USD and sum all the ‘BHP Project Execution’s in cell D5 and so on. I then need to drag this formula across subsequent months (column E onwards).
Can anyone help?
Very much appreciated !
Hi there
Hoping a formula wiz can help me with this… please refer attached excel sheet.
In the highlighted cells I need to input formulas to covert values below to USD – so convert the values in column D, rows 19 to 63 (which are in source currency), by the highlighted rates for each currency in column D rows 66 to 73 – the common link being the text in column B – so convert each source currency value to USD and sum those converted values by the text (in column B) – e.g. convert to USD and sum all the ‘BHP Project Execution’s in cell D5 and so on. I then need to drag this formula across subsequent months (column E onwards).
Can anyone help?
Very much appreciated !
Last edited by a moderator: