google sheets formula to calculate US dollars to rands code example Example: real time currency conversion google sheets =A2*GOOGLEFINANCE("CURRENCY:USDBRL")