Where can excel newbies go for help with formulas?
Posted by Mike on January 28, 2002 12:46 PM
I've never used formulas before, and trying to figure this out is not easy. Any good sites for excel dummies? Bottom line is I want to create a simple formula such that all values in column F are multiplied by 12 in column E.
Posted by Juan Pablo G. on January 28, 2002 12:53 PM
It's not so difficult.
If you want to multiply the value of F2 by 12, and put the result in E2, do this.
Select E2.
Type the following
=F2*12
Hit [Enter]
That's IT ! Formulas are entered with an equal sign at the beginning, and work pretty much the same as "real world math", that is, (5 + 2)*3 + 5 = 26
Juan Pablo G.
Posted by Bariloche on January 28, 2002 12:54 PM
I think you're there
Mike,
It'd be hard to find a better place than this.
To answer your specific need: Select a cell in column E, type =12* and then select the adjacent cell in column F and hit Enter. You should end up with the equation =12*F2 in cell E2 (for example). You may also want to read the Excel Help files on this subject.
enjoy
Posted by Mike on January 28, 2002 1:03 PM
Thank you very much! Last question: how does one choose multiple cells in the column? For example if I wanted to select F2 - F31, multiply it by 12 and have it displayed in column E?
Really appreciate your time.
Posted by Juan Pablo G. on January 28, 2002 1:19 PM
Depends. If you want the results in cells E2 - E31 (By the way, this is represented as E2:E31) do this.
Select E2:E31
Type,
=F2*12
Hit [Control] + [Enter] at the same time.
If, on the other hand, you only want this in ONE cell (Instead of 29), do this.
Select the cell in column E where you want the result.
Type,
=SUM(F2:F31)*12
Hit [Enter]
Juan Pablo G. Thank you very much! Last question: how does one choose multiple cells in the column? For example if I wanted to select F2 - F31, multiply it by 12 and have it displayed in column E? Really appreciate your time.
Posted by Mike on January 28, 2002 1:48 PM
Thank you ;p
Very nice of you and I appreciate it!
