| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy conditional formulas that reference one cell
I would like to "fill down" a conditional "IF" formula while referencing one
cell value in all rows: =IF(D12=0,"",$J3/D12) =IF(D13=0,"",$J3/D13) =IF(D14=0,"",$J3/D14) =IF(D15=0,"",$J3/D15) I thought the $J3 would remain fixed if it was consistantly fixed in at least three rows and had the $ in front of it. What am I doing wrong or is this option not available? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
| Excel 2003 - Copy Cell Reference | Excel Worksheet Functions | |||
| how do i copy a formula's result to another cell, without copying. | Excel Worksheet Functions | |||
| Conditional Formatting using result of Cell Formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
