Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Table equations...
I have a column of wattages and a row of impedances (ohms). I want to
calculate the volts from this table of information without having to type in each cell's formula. I tried copy and paste, but the equation changes part of itself to the column/row before it and not the row/column I want it to use. =SQRT(A2*B1) I want the A2 to stay the same in that row as I go across the columns but the B increment. Ie. C2, D2, E2, etc. Like wise when I increment down the page, I want the B1 to stay the same but have the B2 increment. Ie, B3, B4, B5, etc. This expands to I34. Solution? -- I reject your reality and substitute my own. Promote hydrogen - one of the best "clean" fuels there are! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Table equations...
Try this baby out - =SQRT($A2*B$1) - and copy down/across The $ sign represents an absolute reference, so it won't change the column reference for A when copying down (although it will change the row) vice versa for copying the rows across. Likewise, when $A$1 is copied down or across, the cell reference will never change relative to it's position, it's an absolute absolute reference. So there's your absolute lesson cheers Tony On Dec 13, 4:00 pm, jsc3489 wrote: I have a column of wattages and a row of impedances (ohms). I want to calculate the volts from this table of information without having to type in each cell's formula. I tried copy and paste, but the equation changes part of itself to the column/row before it and not the row/column I want it to use. =SQRT(A2*B1) I want the A2 to stay the same in that row as I go across the columns but the B increment. Ie. C2, D2, E2, etc. Like wise when I increment down the page, I want the B1 to stay the same but have the B2 increment. Ie, B3, B4, B5, etc. This expands to I34. Solution? -- I reject your reality and substitute my own. Promote hydrogen - one of the best "clean" fuels there are! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Table equations...
Worked like a charm! Thanks!
-- I reject your reality and substitute my own. Promote hydrogen - one of the best "clean" fuels there are! "bony_tony" wrote: Try this baby out - =SQRT($A2*B$1) - and copy down/across The $ sign represents an absolute reference, so it won't change the column reference for A when copying down (although it will change the row) vice versa for copying the rows across. Likewise, when $A$1 is copied down or across, the cell reference will never change relative to it's position, it's an absolute absolute reference. So there's your absolute lesson cheers Tony On Dec 13, 4:00 pm, jsc3489 wrote: I have a column of wattages and a row of impedances (ohms). I want to calculate the volts from this table of information without having to type in each cell's formula. I tried copy and paste, but the equation changes part of itself to the column/row before it and not the row/column I want it to use. =SQRT(A2*B1) I want the A2 to stay the same in that row as I go across the columns but the B increment. Ie. C2, D2, E2, etc. Like wise when I increment down the page, I want the B1 to stay the same but have the B2 increment. Ie, B3, B4, B5, etc. This expands to I34. Solution? -- I reject your reality and substitute my own. Promote hydrogen - one of the best "clean" fuels there are! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a Word Table from a Excel Macro | Excel Discussion (Misc queries) | |||
How do I link a cell outside a pivot table to one inside the table | Excel Discussion (Misc queries) | |||
Custom field in Pivot Table? | Excel Discussion (Misc queries) | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) |