I have the following formula in a cell:
=IF(OR(L7=0,$L$2=0),"",SUM(D7-L7))
It works fine BUT what I'd like to emilminate is negative numbers. So if the number being generated is < or = 0 I want the cell to be left blank.
Is there a way do do that?
=IF(OR(L7=0,$L$2=0),"",SUM(D7-L7))
It works fine BUT what I'd like to emilminate is negative numbers. So if the number being generated is < or = 0 I want the cell to be left blank.
Is there a way do do that?