I found many posts where people are asking information regarding the use of formulas and functions (equations) in design tables, but apparently they do not know that inside a design table they can use all the power of Excel including all the standard Excel functions as well as user defined functions (VB code).
Attached is an Excel file which contain a complete detailed description of some of the standard functions available in Excel, as well as examples showing how those functions can be used. This file can be used as a tutorial on how to use Excel functions to perform all type of calculations.
Hope the attached help some people to unleach the power of Excel and use it on Design Tables.
SolidworksConfigurations design Tables