Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keeping the correct cells when making a formula?
I am sure this already answered, but I can not find it, so forgive me in
advance. I created a Excel Spreadsheet to make some forecasts... anyways I have a formula that will always be pulling from the same two cells and one that changes with every cell. So the formula is =(I6*D3)*N3 so the next cell with read =(J6*D3)*N3, and following that =(K6*D3)*N3. Now this is in about 400 columns, and if I drag the cell across to copy all the variables increase. So how can I make sure that the last 2 variables do not change, I need the ability to have them change if I change those respective fields. Hope that makes sense, oh and this is in Excel 2007 but I had the same issue with Excel 2003. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
making a formula that will display a "word" in multile cells | Excel Worksheet Functions | |||
Keeping a sum colum correct after inserting a colum of data in fro | Excel Discussion (Misc queries) | |||
How to copy cells with keeping exact formula intact | Excel Discussion (Misc queries) | |||
Making Excel Calculate In Correct Order | Excel Discussion (Misc queries) | |||
capturing data on multiple students; keeping history; making chart | Excel Discussion (Misc queries) |