Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trying to make a table where one number stays the same
Alright I am trying to write a formula for interest. So far it is =(SUM
X,(Product(X,Y))). Alright the problem i am having is i want my program to look really clean and i have y as the percent interest one would be getting as a number in a cell at the top of the column and i want to be able to use that as a number in my formula that all you see is for example A5. is there anyway that when i continue to carry and copy it down my row that i can keep it as a5. essentially making it some absolute? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
trying to make a table where one number stays the same
To make a cell reference absolute, press <F4. This will insert $ figures
before the A and the 5 in your example, to show $A$5. Pressing <F4 repeatedly, will change the way it is absolutised to eg $A5, A$5 and back to A5.$A5 gives an absolute column, which can be copied across from B to X or whatever. A$5 gives an absolute row, which can be copied down from say row 6 to whatever. $A$5 is absolute column and row wise. -- Hth Kassie Kasselman Change xxx to hotmail "Confused" wrote: Alright I am trying to write a formula for interest. So far it is =(SUM X,(Product(X,Y))). Alright the problem i am having is i want my program to look really clean and i have y as the percent interest one would be getting as a number in a cell at the top of the column and i want to be able to use that as a number in my formula that all you see is for example A5. is there anyway that when i continue to carry and copy it down my row that i can keep it as a5. essentially making it some absolute? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
trying to make a table where one number stays the same
Thanks! i took a class in high school but that has been a while...
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a number have a certain number of characters. | Excel Discussion (Misc queries) | |||
When I make a row absolute, but column relative, the column stays. | Excel Discussion (Misc queries) | |||
Make table query will work in datasheet view but will not make tab | Excel Discussion (Misc queries) | |||
FIX TOP ROW,SO WHEN I SCROLL DOWN IT STAYS AT TOP | Excel Discussion (Misc queries) | |||
How to make a number round up/down to a set number | Excel Worksheet Functions |