youtor.org
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=ZX_DrAmOoUQ
In this HowTech written tutorial, we’re going to show you how to add text to an Excel 2016 formula. • Don't forget to check out our main channel / howtech for more free how-to videos! • Join us on Facebook • / howtechtv • Our App • http://bit.ly/how-tech • First, start off like any other formula, with an equals sign. Text is a string value, thus it must be enclosed in quotation marks. The example shown below uses the formula: [=”Cash: “]. • • To add an actual calculation to the formula after the string value, you must use the ampersand symbol ( ) to concatenate, or add, the calculation on at the end of the formula. • • The below example adds in the actual calculation. • • To add an extra element to the formula, more text for example, simply throw in another ampersand ( ) symbol before the new text. The full formula shown below is as follows: [=”Cash: “ SUM(H8:H107) – SUM(I8:I107) “ dollars”]. Make sure to include the spaces in the string values. • • The result that shows after hitting Enter, or selecting a different cell should be as shown below. A calculation in between two string values that have been concatenated on. • • This is a HowTech tutorial, visit our website and watch our videos for more!
#############################
New on site
