- Registration date
- Thursday July 24, 2014
- Last seen
- May 7, 2021
As long as you drag the formula down Column D as far as you need, you won't need to worry about named ranges.
If the value 302000000 will only ever be in cell A1, you can use an absolute reference for the value in the formula as follows:-
It will thus always reference A1.