View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fred Ernst[_2_] Fred Ernst[_2_] is offline
external usenet poster
 
Posts: 6
Default 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