Current Cell

[tshad]

I have a couple of formulas I want to make relative to the current cell.

In the Cell, I have:

=IF(B2=0,0,B2-COLUMN()/10^10)

I want to change B2 to the current cell. I fill this to the right so that I
have:

=IF(C2=0,0,C2-COLUMN()/10^10)
=IF(D2=0,0,D2-COLUMN()/10^10)
etc

but I am doing this later down the page to start at B8 so that I will now
have:

=IF(B8=0,0,B8-COLUMN()/10^10)

And then after filling right, I will have:
=IF(C8=0,0,C8-COLUMN()/10^10)
=IF(D8=0,0,D8-COLUMN()/10^10)

I will then use the same thing down the page at something like B15.

So I don't want hard code B2. I want to say Current Cell somehow and then
when I copy to the right it would still work.

Is there a way to do this?

Thanks,

Tom