Formulas

­

Calculating Variances with Negative Numbers

A common metric in dashboards and reporting is variance calculation, i.e. comparing a particular data point against a target or previous data point to find the delta.For example, if you have a target of 100, and an actual of 67, then the variance would be -33%. In other words, the Actual is 33% less than the Target.The standard

By |September 22nd, 2015|Excel, Formulas|

Excel String Concatenation

Related Function:CONCATENATEExcel string concatenation, i.e. joining together text strings, can be performed by using the: Ampersand (&) operator, orCONCATENATE functionUsing the Ampersand (&) OperatorThe & Operator, when used between two text strings, tells Excel to return a single text string, consisting of the concatenation of the two original strings.Syntax=text1&" "&text2&" "&[text3]&" ... )Examples ABCDE1FirstNameLastNameDOBFormulaResult2   ="John"&" "&"Jones"John Jones3BarbaraBUSH =A2&" "&B2Barbara BUSH4GeorgeBUSH11/12/85=A3&" "&B3&",

By |September 5th, 2015|Formulas|

Concatenate numbers and text in the same cell using functions

Say, you have a list of names in column A and a list of each person's income in column B, and in column C you want to create a sentence like "John Brown earns $2,800.00 per month". You can use this formula in column C:=CONCATENATE($A8," earns ",$B8," per month") However, the result would beJohn Brown earns

By |March 14th, 2013|Formulas|