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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy conditional formulas that reference one cell
If you're filling down then you need to fix the row number so you need J$3 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=503699 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy conditional formulas that reference one cell
try =IF(D12=0,"",J$3/D12)
putting the $ in front of the row number in stead of the column letter. you do not have to have three of them to make it work.. -- Greetings from New Zealand Bill K "John Sempek Builder" <John Sempek wrote in message ... 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? |
Reply |
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) |