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" <carolan@discussions.microsoft.com> wrote in message
news:E46DEFCF-4217-4406-B664-4C35A92F53D6@microsoft.com...
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
> >.
> >
>