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
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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
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