What will MS Excel return when E2-F2 is entered in a cell?

Solved
Joseph - Aug 25, 2021 at 09:02 AM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Aug 26, 2021 at 11:40 AM
Hello,

What will MS Excel return when E2-F2 is entered into a cell?

System Configuration: Android / Chrome 92.0.4515.159

1 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
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
0