Gokhan_ciftcioglu
New Member
- Joined
- Mar 24, 2017
- Messages
- 30
Are there any way to refer to the formula cell in the written formula. For example, I want to write the below formula in
CELL B1;
=IF(A1="";"cell is blank";ROW(B1))
I want to fill the dotted place in the formula with a function that gives the rownumber of the Cell B2. My purpose is not to write there Row(B1). I need a way or function that I can refer to "formula cell". VBA is useless for this problem.
CELL B1;
=IF(A1="";"cell is blank";ROW(B1))
I want to fill the dotted place in the formula with a function that gives the rownumber of the Cell B2. My purpose is not to write there Row(B1). I need a way or function that I can refer to "formula cell". VBA is useless for this problem.