You want to have text and the result of a formula in the same cell; for example the cell should say “Total Sales Made: ” followed by the result of the calculation to work out annual sales.
Starting Point: Click in the cell in which you want the result.
Script:
Type an equals sign as all formulae start with an equal sign, then type in the required text enclosed within double apostrophes, in this case: “Total Sales Made: “ Now type in an ampersand (&) sign. Now enter the relevant formula, in this case SUM(B4:B25).
Press the Enter key.
Format the cell as required.
Find out more about our Excel training London, UK, or our Excel training Dorset, Wiltshire, Hampshire .
Find out more about our Excel training Sydney, Australia.
Advertisements
Reblogged this on ifonlyidknownthat.