Sum and If combination formula

Hi there,

If I34="1", then I want "1" to be added to J31's balance. If I31="anything
other than 1", "0" should be added to J31's balance. How what kind of
function would I use?

Thanks in advance for your help!

--
Message posted via http://www.officekb.com

Kim

let's say J31 had a simple formula in it, for example, =K31.

You would cahnge this to:

=K31+IF(I31=1,1,0)

If J31 does not have a formula in it, I don't think you can do it.

Regards

Trevor


"Kim via OfficeKB.com" <[email protected]> wrote in message
news:[email protected]...
> Hi there,
>
> If I34="1", then I want "1" to be added to J31's balance. If
> I31="anything
> other than 1", "0" should be added to J31's balance. How what kind of
> function would I use?
>
> Thanks in advance for your help!
>
> --
> Message posted via http://www.officekb.com

Try This:

=IF(I34=1,J31+1,IF(I31<>1,J31,""))

HTH
Michael

"Kim via OfficeKB.com" wrote:

> Hi there,
>
> If I34="1", then I want "1" to be added to J31's balance. If I31="anything
> other than 1", "0" should be added to J31's balance. How what kind of
> function would I use?
>
> Thanks in advance for your help!
>
> --
> Message posted via http://www.officekb.com
>