What will MS Excel return when E2-F2 is entered in a cell?
Solved/Closed
Joseph
-
Aug 25, 2021 at 09:02 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 26, 2021 at 11:40 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 26, 2021 at 11:40 AM
Related:
- What will MS Excel return when E2-F2 is entered in a cell?
- How to enter @ in laptop - Guide
- Ms excel free download - Download - Spreadsheets
- If cell contains date then return value ✓ - Excel Forum
- Alternative for f2 key in excel ✓ - Excel Forum
- Position formula in excel ✓ - Office Software Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Aug 26, 2021 at 11:40 AM
Aug 26, 2021 at 11:40 AM
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
