Formula to return cell value in Excel
Closed
jt13
Posts
1
Registration date
Friday 2 February 2018
Status
Member
Last seen
2 February 2018
-
2 Feb 2018 à 11:33
BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021 - 2 Feb 2018 à 15:43
BrianGreen Posts 1005 Registration date Saturday 17 January 2015 Status Contributor Last seen 30 September 2021 - 2 Feb 2018 à 15:43
Related:
- Excel value of cell
- Excel mod apk for pc - Download - Spreadsheets
- Kernel for excel repair - Download - Backup and recovery
- Excel multiple lines in one cell - Guide
- Arrow keys not working in excel - Guide
- Vat calculation excel - Guide
1 response
BrianGreen
Posts
1005
Registration date
Saturday 17 January 2015
Status
Contributor
Last seen
30 September 2021
149
2 Feb 2018 à 15:43
2 Feb 2018 à 15:43
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.
