Forum Discussion
Cell78
Mar 11, 2019Copper Contributor
sumif or sumifs or sumproduct help
Hi All
i work in global payroll - i have a spread sheet consisting of
Currency ie (usd), salary,bonus, commission, and a fx rate table I need to add the bonus and commission together and * by the correct currency to get my variables in gbp. I have a lot of employees and currency's . what sum can i put in that will add up my variables and then find the correct fx rate and calculate it.
From #startingtogocraxy
1 Reply
- TwifooSilver ContributorPlease attach your sample file to facilitate the determination of the formula applicable to your situation.