Need help writing an Excel macro (I think)

[BigToque]

What I want to do sounds simple.

I have A1, B1 and C1.

C1 stores the value of B1 subtract A1.

What I want is for C1 to display 0 (zero) unless the result of the equation is > 1 (and to display the result)

Is this possible? Is it even a macro?

 

[Len12345]

its just an equation. Type =if and it will show you how to do it. The following will work for your above example.



=IF(A1>B1,A1-B1,0)

EDIT: that might be backwords but I hope you get the idea

 

[BigToque]

actually, i just figured that out...

Thanks for the help