Memorize constants in Excel
You have created your table, and there are several constants used several times (VAT ,per hour, etc. ..).
- Solution 1[Basic]: you write them in your forms, ex: = C3 * 1196 to calculate a TTC value from an HT value.
- Solution 2[Basic]: You enter them into the cells and recall these cells whenever necessary, eg
- you enter 1.196 in B1
- you have your total HT B2
- you enter in C3: = B2 * $B$ 1 .... here, $ will copy the formula to other areas, change references Line /
Column B1 when copies (called absolute reference, as opposed to reference).
- A nicer example to calculate TTC in C3 from a HT tin B2.
- go to: ADD / NAME / DEFINE ... enter VAT rate and then down in the "Refers to" enter 1196, then submit.
- You can now register for example, C3: = B2 * VAT rate, or wherever you need to make this calculation.
The constant VAT rate is stored as the name associated with a value.
Besides mail merge, what are other ways you can share data from excel with other applications