Using true/false to subtract ongoing (monthly payments)variable amount show result

[wfrith2]

I want to decrement B5(a constant) using the results of the entry in D11 (a true/false statement from a drop down box). If result is true (1 in this case), it will subtract C11 ( a varible) from B5 and insert the result in B6. I would like to do this for C11:C34 as D11:D34 becomes true(1). Also as each 'true' updates, the new result is entered in B6. WHEW, my 1st post

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[AliGW]

Your title should explain what you are trying to do - it still doesn't. Please try again. I would make a suggestion if I understood your query ...

[TMS]

If I understand correctly,

Please Login or Register  to view this content.

[wfrith2]

Works Thank You VERY much.

[TMS]

You're welcome.

Thanks for fixing the Thread Title

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.