The grossing up factor in your example is 1.25. You could have a simple
formula in each cell in column 2 -
=A1*1.25
=B1*1.25
However, especially if you have a large spreadsheet, this can be prone to
user error. Find a cell (perhaps on another worksheet within the
spreadsheet) in which you can place this and other variables. define and
name that cell. To do this -
Click on <Insert><Name><Define> and type -
Chris (or any other name you wish).
You may wish to type, in an adjacent cell, a short descriptor of the
variable.
In each of the cell in column 2 type the formula -
=(Chris)
This has the benefits that -
you have to enter (amend) the variable only once
the calculation will be correct even if the variable is moved within the
spreadsheet
if the variable is incorrect it will be, at least, consistently
incorrect.
Regards.
Bill Ridgeway
Computer Solutions
