Formula to return cell value in Excel
Closed
jt13
BrianGreen
- Posts
- 1
- Registration date
- Friday February 2, 2018
- Status
- Member
- Last seen
- February 2, 2018
BrianGreen
- Posts
- 1010
- Registration date
- Saturday January 17, 2015
- Status
- Moderator
- Last seen
- September 30, 2021
Related:
- Formula to return cell value in Excel
- Formula for copying cell contents in excel - Guide
- Excel formula if two cells match return value from third ✓ - Forum - Excel
- Excel formula to return value if cell contains text ✓ - Forum - Excel
- Excel formula to increment cell value by 1 ✓ - Forum - Excel
- Excel putting result of a formula in another cell - Forum - Excel
1 reply
BrianGreen
Updated on Feb 2, 2018 at 04:02 PM
- Posts
- 1010
- Registration date
- Saturday January 17, 2015
- Status
- Moderator
- Last seen
- September 30, 2021
Updated on Feb 2, 2018 at 04:02 PM
I assume you want the formula to be in cell D2. Also, Im not sure this answer is correct as you dont really say if you want a different cell to have this formula, but assuming I'm right here then Im not sure you can do this meaningfully, because as soon as you enter a value into D2 it will overwrite the formula. But this works ... sort of. It adds the words 'Your Default Input' into cell D2 until you overwrite it.
or if you want to enter the contents of another cell (I used contents of A1 in this example) then
Perhaps you should investigate a macro, which will need a button to activate it, so isnt ineractive.
Really we need more information - the data you need to display, the target cell, the cell where the formula will be placed, and the cell where the information you want to display if D2 is empty.
=IF(D2="","Your Default Input")
or if you want to enter the contents of another cell (I used contents of A1 in this example) then
=IF(D2="",A1)
Perhaps you should investigate a macro, which will need a button to activate it, so isnt ineractive.
Really we need more information - the data you need to display, the target cell, the cell where the formula will be placed, and the cell where the information you want to display if D2 is empty.
