Add checkbox

[ambady]

I have a excel sheet with payments and receipts, both has details and an amount.

I have made the sheet.

I want to place a check box near each payment, when check box is selected it runs a formula and that is

Bank balance (placed on top) + sales - payments = Value when check box selected.

When check box is not selected, avoid calculating that payment, but go on to the next payment. If selected again use formula Bank balance + sales - payments.

Can any one help pls.

I am attaching the file.

[6StringJazzer]

Welcome to the forum!

I strongly recommend against using checkboxes for this. You would have to create a checkbox for every possible row where you would have data. It's a maintenance nightmare (unless you write VBA to manage it).

I have attached a solution that simply uses a column to put an "x" (or any other character). When that column is non-blank, the balance is updated. If it is blank, then it just brings the previous balance down without updating.

[ambady]

Thanks a lot for the help.

I want the formula to work without any problem when a sale is made, so X is not required there, only when a payment is given, there is an option to pay or not to pay.

Hope you can make a small correction and help me.

I really appreciate your help. Thanks a lot....

[6StringJazzer]

I want the formula to work without any problem when a sale is made, so X is not required there, only when a payment is given, there is an option to pay or not to pay.

Sorry, I don't understand this explanation. You are also talking about sales and payments in your post, but debits and credits in your file.

Can I assume that

sale=credit
payment=debit

?

It would help to break the conditions down in English. Modify this to explain what you need:

Please Login or Register  to view this content.

[ambady]

Sorry, I don't understand this explanation. You are also talking about sales and payments in your post, but debits and credits in your file.

Can I assume that

sale=credit
payment=debit

..... Correct ? /////correct/////

It would help to break the conditions down in English. Modify this to explain what you need:

Please Login or Register  to view this content.

Hope you understood.

Thanks a lot for helping me.

I also have another question.
Is there any why we can hide the title bar, and tool bar of an excel file saved as an htm file. I just want to bring the feel as if this is not a excel page and insert a jpg file at the top of the page is it possible ?

[6StringJazzer]

Hope you understood.

Sorry, I didn't.

Please Login or Register  to view this content.

I also strongly recommend using consistent language, because mixing credit, sale, debit, and payment is confusing even if though we defined them. Use the same words that are your file.

I also have another question.
Is there any why we can hide the title bar, and tool bar of an excel file saved as an htm file. I just want to bring the feel as if this is not a excel page and insert a jpg file at the top of the page is it possible ?

This question is unrelated to your original question so I recommend starting a new thread for it.