|
It is beyond the scope of this document to outline everything that can be done with a powerful application like Microsoft Excel. However, a great deal can be accomplished using a handful of basic but powerful functions. When setting up product rules some common excel functions are frequently used. The most common functions include the following eight families:
|
|
|
And, Not, Or, True, False
|
Used in logic statements
|
If
|
The IF worksheet function checks a condition that must be either true or false.
|
Iserror
|
Detects errors
|
Left, Right, Mid
|
Selects specific text characters
|
Max, Min
|
Determines the largest or smallest value in a list
|
Proper, Upper , Lower
|
Formats text formatting
|
Round(), RoundDown, Roundup
|
Rounds a calculation to a selected number of decimals
|
Vlookup
|
Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table. This is used frequently and the user should be proficient in the set-up and use of Vlookup.
|
|
