Lesson+1

//Formulas//

//[]//


 * String Functions: ||
 * || ** [|Asc] ** (VBA) || ** [|Find] ** || ** [|Mid] ** || ** [|Substitute] ** ||
 * || ** [|Char] ** || ** [|Fixed] ** || ** [|Proper] ** || ** [|T] ** ||
 * || ** [|Chr] ** (VBA) || ** [|Format] ** (VBA) || ** [|Replace] ** || ** [|Text] ** ||
 * || ** [|Clean] ** || ** [|InStr] ** (VBA) || ** [|Rept] ** || ** [|Trim] ** ||
 * || ** [|Code] ** || ** [|InStrRev] ** (VBA) || ** [|Right] ** || ** [|UCase] ** (VBA) ||
 * || ** [|Concatenate] ** || ** [|LCase] ** (VBA) || ** [|RTrim] ** (VBA) || ** [|Upper] ** ||
 * || ** [|Concatenate with &] ** || ** [|Left] ** || ** [|Search] ** || ** [|Value] ** ||
 * || ** [|CurDir] ** (VBA) || ** [|Len] ** || ** [|Space] ** (VBA) ||  ||
 * || ** [|Dollar] ** || ** [|Lower] ** || ** [|Str] ** (VBA) ||  ||
 * || ** [|Exact] ** || ** [|LTrim] ** (VBA) || ** [|StrConv] ** (VBA) ||  ||


 * Numeric / Mathematical Functions: ||
 * || ** [|Abs] ** || ** [|CountIf] ** || ** [|Minverse] ** || ** [|Small] ** ||
 * || ** [|ACos] ** || ** [|Degrees] ** || ** [|Mmult] ** || ** [|Sqrt] ** ||
 * || ** [|ACosh] ** || ** [|Even] ** || ** [|Mod] ** || ** [|Subtotal] ** ||
 * || ** [|ASin] ** || ** [|Exp] ** || ** [|Odd] ** || ** [|Sum] ** ||
 * || ** [|ASinh] ** || ** [|Fact] ** || ** [|Pi] ** || ** [|SumIf] ** ||
 * || ** [|ATan] ** || ** [|Fix] ** (VBA) || ** [|Power] ** || ** [|SumProduct] ** ||
 * || ** [|ATan2] ** || ** [|Floor] ** || ** [|Product] ** || ** [|SumSq] ** ||
 * || ** [|ATanh] ** || ** [|Format] ** (VBA) || ** [|Radians] ** || ** [|SumX2mY2] ** ||
 * || ** [|Atn] ** (VBA) || ** [|Int] ** || ** [|Rand] ** || ** [|SumX2pY2] ** ||
 * || ** [|Average] ** || ** [|Large] ** || ** [|Rnd] ** (VBA) || ** [|SumXmY2] ** ||
 * || ** [|AverageA] ** || ** [|Ln] ** || ** [|Roman] ** || ** [|Tan] ** ||
 * || ** [|Ceiling] ** || ** [|Log] ** || ** [|Round] ** || ** [|Tanh] ** ||
 * || ** [|Combin] ** || ** [|Log10] ** || ** [|RoundDown] ** || ** [|Trunc] ** ||
 * || ** [|Cos] ** || ** [|Max] ** || ** [|RoundUp] ** || ** [|Val] ** (VBA) ||
 * || ** [|Cosh] ** || ** [|MaxA] ** || ** [|Sgn] ** (VBA) || ** [|Var] ** ||
 * || ** [|Count] ** || ** [|Mdeterm] ** || ** [|Sign] ** || ** [|VarA] ** ||
 * || ** [|CountA] ** || ** [|Min] ** || ** [|Sin] ** || ** [|VarP] ** ||
 * || ** [|CountBlank] ** || ** [|MinA] ** || ** [|Sinh] ** || ** [|VarPA] ** ||


 * Statistical Functions: ||
 * || ** [|AveDev] ** || ** [|Growth] ** || ** [|Percentile] ** || ** [|StDevP] ** ||
 * || ** [|Average] ** || ** [|Intercept] ** || ** [|PercentRank] ** || ** [|StDevPA] ** ||
 * || ** [|AverageA] ** || ** [|Large] ** || ** [|Permut] ** || ** [|Var] ** ||
 * || ** [|BetaDist] ** || ** [|Max] ** || ** [|Quartile] ** || ** [|VarA] ** ||
 * || ** [|BetaInv] ** || ** [|MaxA] ** || ** [|Rank] ** || ** [|VarP] ** ||
 * || ** [|BinomDist] ** || ** [|Median] ** || ** [|Small] ** || ** [|VarPA] ** ||
 * || ** [|Covar] ** || ** [|Min] ** || ** [|StDev] ** ||  ||
 * || ** [|Forecast] ** || ** [|MinA] ** || ** [|StDevA] ** ||  ||


 * Logical Functions: ||
 * || ** [|And] ** || ** [|If] ** || ** [|IF-THEN-ELSE] ** (VBA) || ** [|True] ** ||
 * || ** [|Case] ** (VBA) || ** [|Nested Ifs] ** (up to 7) || ** [|Not] ** ||  ||
 * || ** [|False] ** || ** [|Nested Ifs] ** (more than 7) || ** [|Or] ** ||  ||


 * Information Functions: ||
 * || ** [|Cell] ** || ** [|IsErr] ** || ** [|IsNull] ** (VBA) || ** [|N] ** ||
 * || ** [|Error.Type] ** || ** [|IsError] ** || ** [|IsNumber] ** || ** [|NA] ** ||
 * || ** [|Info] ** || ** [|IsLogical] ** || ** [|IsNumeric] ** (VBA) || ** [|Type] ** ||
 * || ** [|IsBlank] ** || ** [|IsNA] ** || ** [|IsRef] ** ||  ||
 * || ** [|IsDate] ** (VBA) || ** [|IsNonText] ** || ** [|IsText] ** ||  ||


 * Date & Time Functions: ||
 * || ** [|Date] ** || ** [|DateSerial] ** (VBA) || ** [|Minute] ** || ** [|TimeSerial] ** (VBA) ||
 * || ** [|Date] ** (VBA) || ** [|DateValue] ** || ** [|Month] ** || ** [|TimeValue] ** ||
 * || ** [|DateAdd] ** (VBA) || ** [|Day] ** || ** [|MonthName] ** (VBA) || ** [|Today] ** ||
 * || ** [|DateDif] ** || ** [|Days360] ** || ** [|Now] ** || ** [|Weekday] ** ||
 * || ** [|DateDiff] ** (VBA) || ** [|Format] ** (VBA) || ** [|Second] ** || ** [|WeekdayName] ** (VBA) ||
 * || ** [|DatePart] ** (VBA) || ** [|Hour] ** || ** [|Time] ** || ** [|Year] ** ||


 * Database Functions: ||
 * || ** [|DAverage] ** || ** [|DGet] ** || ** [|DProduct] ** || ** [|DSum] ** ||
 * || ** [|DCount] ** || ** [|DMax] ** || ** [|DStDev] ** || ** [|DVar] ** ||
 * || ** [|DCountA] ** || ** [|DMin] ** || ** [|DStDevP] ** || ** [|DVarP] ** ||


 * Lookup / Reference Functions: ||
 * || ** [|Address] ** || ** [|GetPivotData (Ex #1)] ** || ** [|Indirect] ** || ** [|Rows] ** ||
 * || ** [|Areas] ** || ** [|GetPivotData (Ex #2)] ** || ** [|Lookup] ** || ** [|Switch] ** (VBA) ||
 * || ** [|Choose] ** || ** [|HLookup] ** || ** [|Match] ** || ** [|Transpose] ** ||
 * || ** [|Column] ** || ** [|Hyperlink] ** || ** [|Offset] ** || ** [|VLookup] ** ||
 * || ** [|Columns] ** || ** [|Index] ** || ** [|Row] ** ||  ||


 * More Lookup Functions: ||
 * || ** [|Two-Dimensional Lookup (Example #1)] ** ||  ||
 * || ** [|Two-Dimensional Lookup (Example #2)] ** ||  ||
 * || ** [|Two-Dimensional Lookup (Example #3)] ** ||  ||
 * || ** [|Two-Dimensional Lookup (Example #4)] ** ||  ||


 * Data Type Conversion Functions: ||
 * || ** [|CBool] ** (VBA) || ** [|CDate] ** (VBA) || ** [|CInt] ** (VBA) || ** [|CStr] ** (VBA) ||
 * || ** [|CByte] ** (VBA) || ** [|CDbl] ** (VBA) || ** [|CLng] ** (VBA) || ** [|CVar] ** (VBA) ||
 * || ** [|CCur] ** (VBA) || ** [|CDec] ** (VBA) || ** [|CSng] ** (VBA) ||  ||


 * Financial Functions: ||
 * || ** [|Db] ** || ** [|Irr] ** || ** [|Npv] ** || ** [|Rate] ** ||
 * || ** [|DDb] ** || ** [|ISPmt] ** || ** [|Pmt] ** || ** [|SLn] ** ||
 * || ** [|FV] ** || ** [|Mirr] ** || ** [|PPmt] ** || ** [|Syd] ** ||
 * || ** [|IPmt] ** || ** [|NPer] ** || ** [|PV] ** || ** [|Vdb] ** ||


 * File/Directory Functions: ||
 * || ** [|ChDir] ** (VBA) || ** [|Dir] ** (VBA) || ** [|FileLen] ** (VBA) || ** [|MkDir] ** (VBA) ||
 * || ** [|ChDrive] ** (VBA) || ** [|FileDateTime] ** (VBA) || ** [|GetAttr] ** (VBA) || ** [|SetAttr] ** (VBA) ||


 * Miscellaneous Functions: ||
 * || ** [|Test a string for an alphanumeric value] ** ||
 * || ** [|Convert currency into words] ** ||
 * || ** [|How to Autonumber in Excel] ** ||
 * || ** [|Delimit values with Ascii 29 character] ** ||
 * || ** [|Creating a custom round function] ** ||
 * || ** [|Creating a custom average function (that excludes outlyers from the calculation)] ** ||

//From:( //[])