Subtraction of 2 numbers/cells

[Cipri]

Could anyone please help me with this situation (in Excel 2003):
I have 2 cells
A1 = 0 and B1 = 10
In cell C1 i put this formula C1=A1-B1 . Now the answer will be C1=
-10 but my question is:
Is there a formula to calculate in C1 the result if the answer is positive
and if the answer is negative to put 0?

Thank you in advance.

 

[מיכ×ל (מיקי) ×בידן]

Try one of two:
=(A1-B1)*(A1>B1)
=(A1-B1)*(A1>=B1)
Micky

 

[Cipri]

It worked your solution and in the mean time i found another one that works
too
if(A1<B1,"0",A1-B1)

Thx dude

 

[Bernard Liengme]

But do not put the zero in quotes, that will make it text
if(A1<B1,0,A1-B1)
best wishes

 

[David Biddulph]

=MAX(0,A1-B1)