Forum Discussion
formulas and functions
Hi im new to excel and dnt know what im doing lol, what is the formula for multiplying column d by e to get answer in g? for example im trying to work out the kms i drive to a job(D) multiplied by .7...
Maree,
Welcome to the Tech Community! Hopefully we can get you going in the right direction.
Just to make sure we're on the same page to start, you can enter data in any cell by typing it, or copying and pasting it. But, when you want cells to calculate or manipulate other data, you begin in the cell where you want things to appear, and you always start with an equal sign.
So, if you have data in cell D2 that you want multiplied by cell E2 with the result appearing in cell G2, you could type this in cell G2:
=D2*E2
You can either type this formula as you see above, or you can type "=" then click the first cell with your mouse (D2) then type "*" then click the next cell (E2).
To have the same formula work for the entire column G, the easiest way is to drag the fill handle down. Go here for information about that: https://support.office.com/en-us/article/Copy-a-formula-by-dragging-the-fill-handle-in-Excel-2016-for-Mac-dd928259-622b-473f-9a33-83aa1a63e218
The article is for Excel 2016 for Mac but works the same for all versions of Excel.
When you want to do more advanced things, check out Absolute and Relative references. Hopefully this helps you out!
Welcome to the Tech Community! Hopefully we can get you going in the right direction.
Just to make sure we're on the same page to start, you can enter data in any cell by typing it, or copying and pasting it. But, when you want cells to calculate or manipulate other data, you begin in the cell where you want things to appear, and you always start with an equal sign.
So, if you have data in cell D2 that you want multiplied by cell E2 with the result appearing in cell G2, you could type this in cell G2:
=D2*E2
You can either type this formula as you see above, or you can type "=" then click the first cell with your mouse (D2) then type "*" then click the next cell (E2).
To have the same formula work for the entire column G, the easiest way is to drag the fill handle down. Go here for information about that: https://support.office.com/en-us/article/Copy-a-formula-by-dragging-the-fill-handle-in-Excel-2016-for-Mac-dd928259-622b-473f-9a33-83aa1a63e218
The article is for Excel 2016 for Mac but works the same for all versions of Excel.
When you want to do more advanced things, check out Absolute and Relative references. Hopefully this helps you out!