Ignoreing Negative Figures

[The Crazy Shepherd]

OK, what i need to do is subtract one cell from another, if it produces a negative figure i would it to reed as 0. is there any way of doing this.
I'm using MS Excel 2007 and windows 7
Thanks in advance

 

[Aladin Akyurek]

OK, what i need to do is subtract one cell from another, if it produces a negative figure i would it to reed as 0. is there any way of doing this.

Thanks in advance

Try...

=MAX(0,A2-B2)

 

[The Crazy Shepherd]

Thanks for your help, works great

 

[Aladin Akyurek]

Thanks for your help, works great

You are welcome. Thanks for providing feedback.