What will MS Excel return when E2-F2 is entered in a cell?
Report
Joseph
-
TrowaD
TrowaD
- Posts
- 2817
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 14, 2021
Related:
- What will MS Excel return when E2-F2 is entered in a cell?
- Pop up message in excel if a specific word is entered into a cell ✓ - Forum - Excel
- Excel returns FALSE sometimes.... why ✓ - Forum - Excel
- Excel return value if cell contains ✓ - Forum - Excel
- Excel change font color based on value of another cell ✓ - Forum - Excel
- Excel - Insert the Path and File Name in a Cell - How-To - Excel
1 reply
TrowaD
- Posts
- 2817
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 14, 2021
Hi Joseph,
Your computer won't explode when you do, so you can just try it :).
Putting E2-F2 in a cell without the '=', thus not being a formula, Excel will recognise it as a string of text. So the cell will read E2-F2.
Putting an '=' in front of it, turns it into a formula. Now the result will depend on the values entered in E2 and F2.
Best regards,
Trowa
Your computer won't explode when you do, so you can just try it :).
Putting E2-F2 in a cell without the '=', thus not being a formula, Excel will recognise it as a string of text. So the cell will read E2-F2.
Putting an '=' in front of it, turns it into a formula. Now the result will depend on the values entered in E2 and F2.
Best regards,
Trowa
