0
Thanks

A few words of thanks would be greatly appreciated.

Excel - Define and store constant values



You have created your table, and there are several constants that are used several times (VAT, rate schedule, etc. ..).
  • Basic solution 1: define them in your formulas, eg =C3*1,196.
  • Basic solution 2: you enter into cells and call these values whenever necessary
    • 1,196 in B1
    • You can have your total HT in B2
    • In C3: = B2*$B$1.... here $ you will copy the formula to other places, without modifying the references.

Another solution: for example, to obtain the VAT value in C3 based from a value stored in B2.
  • Go to: INSERT / NAME / DEFINE ... enter "VATrate", then down in "Refers to" enter 1.196 and validate.
  • In C3 enter : =B2*TVATrate

VATrate is a constant is stored as NAME, associated with a value.
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Related

This document, titled « Excel - Define and store constant values », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

0 Comments