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" wrote in message
...
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