View Single Post
  #44  
Old 05-11-2009, 04:06 PM
BG5150's Avatar
BG5150 BG5150 is offline
Member
Non-Actuary
 
Join Date: Jan 2009
Favorite beer: the one you're buying me
Posts: 22,298
Default

Quote:
Originally Posted by Ron Weasley View Post
Press F4
That doesn't help me with the original formula.

I Have a number in A1. I also have a list of other numbers in A2, A3, A4...

I need to multiply A1 * A2 and put it into B2, A1*A3 in B3, A1*A4 in B4, etc.

I also have a number in D1 and I need to multiply it by D2, D3, D4, etc and put the result next to it.

So, my first formula, in B2, I hit "+", click A1, *, click A2, enter. Then F2, edit the A1 to $A$1. Then copy the formula down all the rows.

I do the same thing for the second formula with D1.

Is there anyway to, when I click A1, to make it $A$1 in my formula?
Reply With Quote
 
Page generated in 0.08931 seconds with 9 queries