Formula for adding back value?

[joromajr]

-- Question-

I need a formula for adding back value of a cell?

Let us say...

B1 c1 d1 e1
f1 g1 h1
Inv. Amt. Check1# Chk1 Amt. Chk1Status Check2# Chk2 Amt. Chk2Status

Under I1 is the balance. When the word "bounce" is encoded under
"Chkstatus" the check amout should add back to balance.

Please help need it badly.
joromajr

 

[M Kan]

Here's a formula that works

B3-SUM(D3,G3)+I2+(D3*--(E3="bounce"))+(G3*--(H3="bounce"))

the -- converts the logical test of E3="bounce" into a 1 or a 0

I2 is the beginning balance. Let me know if you want me to send you my test
sheet

 

[Dave Peterson]

In this case, the -- aren't necessary. Doing arithmetic (including multiplying)
will coerce those true/false to 1/0's, too.

=B3-SUM(D3,G3)+I2+(D3*(E3="bounce"))+(G3*(H3="bounce"))

 

[M Kan]

Hmmm, the first time I wrote that without the --, I got a #value error, but I
guess it just required the (E3="bounce") be encased in parens

 

[joromajr]

-- Please send me your test sheet
joromajr

Here's a formula that works

B3-SUM(D3,G3)+I2+(D3*--(E3="bounce"))+(G3*--(H3="bounce"))

the -- converts the logical test of E3="bounce" into a 1 or a 0

I2 is the beginning balance. Let me know if you want me to send you my test
sheet

 

[joromajr]

-- Thank you, it work just fine
joromajr

Here's a formula that works

B3-SUM(D3,G3)+I2+(D3*--(E3="bounce"))+(G3*--(H3="bounce"))

the -- converts the logical test of E3="bounce" into a 1 or a 0

I2 is the beginning balance. Let me know if you want me to send you my test
sheet