N function returns a value as a number, and since B1 is text, it is "ignored" in the subtraction.

see here for more info:
https://support.microsoft.com/en-us/...a-29733d1278c9

and try removing the N function and you will see the different result