Saturday, July 6, 2013

Tips on using constants in Formulas

If you are creating a formula that needs to use a constant (this is what we call them here, its not a official name), then you need to know how to use them accurately in order for them to work.

The Basics

All the constants are basically just symbols which represent a particular function. The function is basically an operation which is performed on a specific part of the formula. Here are a few points to remember : 

  1. The specific part on which the constant acts or operates is denoted by simple brackets. That is, this part starts which a ( and ends with a )
  2. The operation can either just place a number or can act on a set of numbers or variables. For example. If you use the constant for pi in a formula, then it will simply be replaced by its value and will not have any effect on rest of the formula. Thus, 2*Π*r becomes 2*3.1416*r
  3. The operation can also act upon a set of numbers or/and variables. For instance,  the power constant which is used in this form : ρ(r,4) operates on r and 4, calculating it as r to the power of 4. Another example of the power function can be something like   ρ((r+1),(n-1)). In such a case, as both the base and power are not a single number, thus the brackets make the function work.