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.

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 Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Original article published by . Translated by jak58. Latest update on by jak58.

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 (https://ccm.net/).