![]() |
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