View Single Post
  #1   Report Post  
Carolan
 
Posts: n/a
Default LEAVE BLANK IF NEGATIVE

I know this can be done.....just don't know how. Trying to create a formula
that would leave the cell Column C1 empty if the result of Column A1
minus-Column B1 is negative. If A1 -B1 is positive it would enter the
result. Help please!!!!

If A1 - B1 = Positive figure, enter the result in C1
If A1 - B1 = Negative figure, do not enter result in C1

--
Carolan