While traveling in India, Sabina notes all of her daily expenses in rupees in her spreadsheet. At the end of the day, she wants to see how much each expense was in U.S. dollars.

Question

anonymous · Answer

Which is the quickest way she can convert the currency values?

anonymous · Answer

INR-to-USD multiplier: 0.022346 (Google)
SUM and then multiply the sum by this

anonymous · Answer

okay, you do not need to sum expenses
put expenses in a column, e.g. A1:A10
put the multiplier in C1
put the formula = $C$1*A1 in B1
fill B2:B10 with the formula in B1

anonymous · Answer

okay i got it :)