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 January 16, 2023 - Aug 26, 2021 at 11:40 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Aug 26, 2021 at 11:40 AM
Related:
- What will MS Excel return when E2-F2 is entered in a cell?
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Excel if cell contains date then return value ✓ - Office Software Forum
- Excel date format dd.mm.yyyy - Guide
- If cell contains specific text then return value in another cell vba ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
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