If statement

[Baseball15]

Sorry this seems simple but not working for me.
I want to compare to see if c4 > n4.
If c4 > n4 subtract n4 from c4 else put a zero in the cell

This isn't working for me.
c4 currently equal to 35,844
n4 currently equal to 24,852
P4 should be 10992 but it puts a dash in the cell.

Here is what I entered in P4.
=IF (c4>n4,c4-n4,0)

Thanks in advance for your assistance.

 

[Joe4]

Welcome to the Board!

I am assuming that you do not really have a space between the word IF and the left parenthesis.

Are both of your entries numbers, or "numbers added as text"?
An easy way to tell is the to enter the following formulas somewhere:
=ISNUMBER(C4)
=ISNUMBER(P4)

If either returns FALSE, then you do not have a valid number entry in that cell.

BTW, another way to do what you want is like this:

=MAX(C4-P4,0)