MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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!