Formula <0 leave cell blank

[Whit]

I want A3 to =A1+A2, but how can I make A3 remain blank if it doesn't meet a
certain condition such as >0.

Whit

[CLR]

=IF(A1+A2>0,A1+A2,"")

Vaya con Dios,
Chuck, CABGx3


"Whit" <Whit@discussions.microsoft.com> wrote in message
news:034C115E-8776-495F-B146-03D1D46F527F@microsoft.com...
> I want A3 to =A1+A2, but how can I make A3 remain blank if it doesn't meet
a
> certain condition such as >0.
>
> Whit

[Dave Peterson]

if(a1+a2<=0,"",a1+a2)



Whit wrote:
>
> I want A3 to =A1+A2, but how can I make A3 remain blank if it doesn't meet a
> certain condition such as >0.
>
> Whit

--

Dave Peterson

[Paul B]

Whit, try this,
=IF(A1+A2>0,A1+A2,"")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Whit" <Whit@discussions.microsoft.com> wrote in message
news:034C115E-8776-495F-B146-03D1D46F527F@microsoft.com...
> I want A3 to =A1+A2, but how can I make A3 remain blank if it doesn't meet
a
> certain condition such as >0.
>
> Whit