Write back methods and commands
By default, writeback methods are additive - they increase existing values in a variety of ways. However, the default syntax of each writeback method can be amended to subtract values and to specify values by a percentage.
In this section, the examples of syntax of Weighted, Equal, To each leaf and Like allocation, [value] can be prefixed with the minus sign (-) to write negative values and/or followed by the percentage sign (%) to amend values by a percentage.
| Syntax | Explanation |
|---|---|
| &W20 | Adds 20 to the cell value |
| &W-20 | Subtracts 20 from the cell value |
| &W5% | Increases the cell value by 5% |
The plus (+) sign is implicit but you can make it explicit (for example,
&W+20). Each writeback method supports two or three syntaxes. For example,
#W[value]and
#@[value] are equivalent.
Examples which contain specific dimension and element names are based on the Best Practices sample database supplied with Office Plus.