Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|