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

Report
-
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
-
Hello,

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

System Configuration: Android / Chrome 92.0.4515.159

1 reply

Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
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