Formula

[Robert]

Hello,

If user enters a value greater than zero in a given cell
then the cell is equal to the value in Staff!D2.
The problem I need the Staff!D2 to stay constant when I
drag the formula to other cells. See below:

This what I do when I drag the formula down:
=IF(C13>0,Staff!D2,"")
=IF(C14>0,Staff!D3,"")
=IF(C15>0,Staff!D4,"")
=IF(C16>0,Staff!D5,"")
=IF(C17>0,Staff!D6,"")

This is what I want it do:
=IF(C13>0,Staff!D2,"")
=IF(C14>0,Staff!D2,"")
=IF(C15>0,Staff!D2,"")
=IF(C16>0,Staff!D2,"")
=IF(C17>0,Staff!D2,"")

I know I can go to each cell and change the Value_if_true
to Staff!D2 but I would have do this for thousands of
cells.

I was just wondering if there is an easier way to have the
Logical_Test change like it is suppose to (ie C13, C14,
etc) but the Value_if_true stay the same (ie Staff!D2).

Or is there way to come back and change all the
Value_if_true to Staff!D2.

Thanks for any help.

 

[Kolyan]

Robert,

You simply can "anchor" the column, column # 2 in this case
Do this via dollar sign, e.g. Staff!D$2

cheers,
Kolyan