Method 1 – Currency Conversion Applying Division Formula Steps: Add a new column on the right side to convert the INR into USD. Add new rows in the dataset that explain the conversion rate of INR to USD. Go to Cell D5. Put the following formula: =C5/$C$13 Press the Enter button...
If you need to convert the entire table, not just 1 cell, place your mouse cursor to the lower right corner of the cell with the formula until it turns into a small black cross: Left-click and drag it across the column to fill in the formula. Release the button to see the results:...