Formula Assistance (

[Guest]

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(ifI32<0:G32) Any advise would be
greatly appreciated.
Kind regards
Martha

 

[Bob Phillips]

=IF(I32=0,G32,"")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Guest]

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,"")

The "" just means "if I32 <>0 then don't stick anything at all in there".
Otherwise, the formula will return a FALSE value.

HTH

Peter