Who else wants to know the secret to Excel Formulas?Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll today
Ever wanted to multiply two different numbers together in Microsoft Excel? The great thing about Excel is that you don’t need to use a calculator to do it – Excel can do it for you! But we need to tell Excel what to do first!
- Type the numbers into Excel that you want to “times by”. Make sure they are in two different cells (a cell is one of those little square boxes you see)
- Click on the cell where you want the answer to appear
- Start typing the following formula. Firstly, hit the equals key, then select the first number, then add a “multiply” symbol – which in this case is the star on the 8 key (shift 8), then select the second number and hit enter
- Your answer will appear!
If you want to take a look at the formula we just created together, click on the cell where the answer appears. Look up in the formula bar (just below the ribbon) you will see something like =A1*A2. Don’t worry if it doesn’t make sense at the moment, the best way to look at it is to read it out loud. In this case “this cell equals whatever is in cell A1 times whatever is in cell A2”. Simple!
’till next time!