Simple question I'm too lazy to answer but still need some help on

Z

Zerex71

Greetings,

Here's my question:

Say I have the following I want to implement (each value is in its own
cell):

NEW BALANCE = CURRENT BALANCE - DEBITS

But I want the value of NEW BALANCE to change only when the PAID field
next to DEBITS (not shown) is checked (or has some sentinel value in
it, like a checkmark, radio box, value=1, etc.) Is there a way to do
this? I'm sure I'll figure it out soon but I was wondering about this
this morning and wanted to poll the group to see if anyone has done
such a thing before.

Thanks,
Mike
 
R

Ragdyer

New is in Column A
Current is in Column B
Debits is in Column C
Paid is in Column D

=(D2<>"")*(B2-C2)
 
Z

Zerex71

Hi there,

That might work but the logic doesn't seem right...I need an IF-ELSE
type result, where if there is something in D2, A2 = B2-C2, but if
there is nothing in D2, A2=B2. Make sense? I don't see quite how this
will work but again, I haven't had time to try it yet today.
 
R

Ragdyer

OK, you didn't stipulate that A2 should equal B2 if D2 was empty.
So, try this instead:

=B2-(D2<>"")*C2
 
Top