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

=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
.

Try this:

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

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Carolan" wrote in 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

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
.