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

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

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

Try this:

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

Hope this helps.

Pete

On Feb 20, 4:49 pm, "Fred Ernst" wrote:
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

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

Try:

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

"Fred Ernst" wrote:

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