software

I want to put a formula into a cell that will accomplish the following:

Entry for Cell A40, If cell I32 is $0 then populate (cell A40) with total in
cell G32

I was trying some varieties of ... =sum(ifI32lt;0:G32) Any advise would be
greatly appreciated.
Kind regards
Martha

=IF(I32=0,G32,quot;quot;)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;MarthaMarthaquot; gt; wrote in message
...
gt; I want to put a formula into a cell that will accomplish the following:
gt;
gt; Entry for Cell A40, If cell I32 is $0 then populate (cell A40) with total
in
gt; cell G32
gt;
gt; I was trying some varieties of ... =sum(ifI32lt;0:G32) Any advise would
be
gt; greatly appreciated.
gt; Kind regards
gt; Martha
Martha --

I'm not sure what you're trying to do with the 'sum' part of your formula.
If I understand your objective, my formula in cell A40 would be:

=if(I32=0,G32,quot;quot;)

The quot;quot; just means quot;if I32 lt;gt;0 then don't stick anything at all in therequot;.
Otherwise, the formula will return a FALSE value.

HTH

Peter

quot;MarthaMarthaquot; wrote:

gt; I want to put a formula into a cell that will accomplish the following:
gt;
gt; Entry for Cell A40, If cell I32 is $0 then populate (cell A40) with total in
gt; cell G32
gt;
gt; I was trying some varieties of ... =sum(ifI32lt;0:G32) Any advise would be
gt; greatly appreciated.
gt; Kind regards
gt; Martha