Make cell value zero if cell formula returns value less than zero?

[Fred Ernst]

Is there an easy way, such as a format setting, to make a cell value zero if
the cell's formula returns a value less than zero?

I've used a conditional statement with the SIGN function before, but I have
existing cells with formulas that I would just like to apply a format to if
possible.

=IF(SIGN(+L7+N7+P7-K7)=-1,0,+L7+N7+P7-K7)


Thank you,
Fred

 

[Pete_UK]

Try this:

=MAX(L7+N7+P7-K7,0)

Hope this helps.

Pete

 

[Guest]

Try:

=max(L7+N7+P7-K7,0)

 

[GIna]

If somebody could please advise. I have 4 numbers (both positive and negative) and I am looking for the max number, but if it is greater than zero, i only want to return zero.