IF question formatting help

[GhostC6]

I am trying to format an excel document and need some help. I had a few courses in Excel and was a wizard with it but my old-timers is kicking in and I cannot figure out how to do something and hope you guys can help. Excel really is one of those things that the more you use it the better.

My goal is this:

I want to be able to do a formula that says the following. If the sum of A1-A2 is less than 0, it displays 0, if the sum of A1-A2 is more than 0, it will display the value of A1-A2.

Is this possible and if so how do I do it? I have looked and found similar actions but not exact and they did not work for me. The actual cells are not A1 and A1 but actually R57 and S57.

Thanks for any help you can give me.

Rick

[Root_]

Is this what you need?

=MAX(0,A1-A2)

[Shareez Saleem]

=if(sum(r57,s57)<0,0,sum(r57,s57))

[GhostC6]

Thank you both very much, the =MAX(0,A1-A2) worked perfect, I tried them both and that one worked. The other one returned a value other than 0 and it should have been 0, I think it either added the R57 and S57 or it posted the value of S57, not sure but the one by Root_ fixed it, thank you both so much!

[GhostC6]

Hey guys and girls, what about changing the font color, I am working with the currency format, I would like a positive amount to be one color and a negative amount to be another color.

Example would be a Positive number of $100.00

A Negative amount of $100.00

Something like that, can that be done also?

Thanks again, you all are great!