You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hi, I have a row of US$ amounts that I want to add and simultaneously convert into another currency in the Total Column.
I'd appreciate if you experts could let me know if possible, and if so, then how.
Many thanks,
Greg
SUM them first then convert the result, like shown below:
=CURRENCYCONVERT(SUM(B2:E2),"eur")
SUM them first then convert the result, like shown below:
=CURRENCYCONVERT(SUM(B2:E2),"eur")
Thanks Badunit. Appreciate your insight.
SUM and CURRENCYCONVERT together in one cell?
