D DSP Varma Member Jan 16, 2017 #1 I need a shortcut to convert different currencies into dollar based on the currency rate given in the table p6:q10. Given is the Raw Data and Desired Result Table. Is there a way to get the desired result using formula? Attachments Test1.xlsx 12.2 KB · Views: 8
I need a shortcut to convert different currencies into dollar based on the currency rate given in the table p6:q10. Given is the Raw Data and Desired Result Table. Is there a way to get the desired result using formula?
B bosco_yip Excel Ninja Jan 16, 2017 #2 Please check as per attachment Regards Attachments Test1(1).xlsx 13.4 KB · Views: 26