In Excel, it is better to separate numbers and formulas into different cells. For example, if you wish to multiple by a row of numbers by a certain rate, it is better to create one row of numbers and another row for the rate. Then add in a 3rd row to multiple the first 2 rows together. In this way, you can always see your numbers and rate you entered and you can also change the rates easily. Do not try to save rows by putting the number and rate into one cell or row.

Leave a Reply