Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Zerex71 - 21 Jul 2006 18:29 GMT
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
Ragdyer - 21 Jul 2006 18:45 GMT
New is in Column A
Current is in Column B
Debits is in Column C
Paid is in Column D

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

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> Greetings,
>
[quoted text clipped - 14 lines]
> Thanks,
> Mike
Zerex71 - 21 Jul 2006 21:44 GMT
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.

> New is in Column A
> Current is in Column B
[quoted text clipped - 28 lines]
> > Thanks,
> > Mike
Ragdyer - 21 Jul 2006 22:13 GMT
OK, you didn't stipulate that A2 should equal B2 if D2 was empty.
So, try this instead:

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

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> Hi there,
>
[quoted text clipped - 35 lines]
>> > Thanks,
>> > Mike
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.