1 Use the fill handle or copy and paste to copy the VALUE function in cell E1 to cell E2. 2  The number 20 should appear in cell E2 and be aligned on the right side of the cell. 3  Type =SUM(E1: E2) into cell E3 and press the Enter key on the keyboard.4  An answer of 30 should appear in cell E3.onverting the Text Data to Numbers with the VALUE Function. 1  Click on cell E1 in the worksheet. 2  Click on the Formulas tab of the ribbon menu. 3  Choose Text from the ribbon to open the function drop down list. 4  Click on VALUE in the list to bring up the function's dialog box. 5  In the dialog box, click on the Text line.
Wall Street doesn't seem to think the marriage of AT&T and Time Warner is a smart move -- particularly at this price. AT&T's $107.50 a share offer for the company is 19% higher than where Time Warner's stock is trading currently, and 35% over where it was before the rumors started.
Find the latest price of the stock of which you would like to calculate dividend yield. As of the November 19, 2010, market close AT&amp;T stock, for example, was priced at $28.32. Divide the stock's dividend per share by its current stock price. For AT&amp;T, divide $1.68 by $28.32. You come up with a result of 0.059. Carry the decimal point two places to the right to come up with the percentage, which is 5.9.