ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Current Cell (https://www.excelbanter.com/charts-charting-excel/167604-current-cell.html)

tshad[_2_]

Current Cell
 
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




All times are GMT +1. The time now is 02:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com