View Single Post
  #4   Report Post  
Carolan
 
Posts: n/a
Default

Thank you!!!!

"Jason Morin" wrote:

=IF(A1-B1=0,A1-B1,"")

HTH
Jason
Atlanta, GA

-----Original Message-----
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
.