Formula or Macro

[data808]

Hello,
I have this spreadsheet that I use for cashiering and it has columns for taking money. The columns are in this order:

Amount Due
Check
Charge
Cash Given
Change

I would like these columns to add everything up so the Change column tells me how much to give back to the customer. The thing is, when the customer writes a check or charges, I want the Change column to say 0 because when the customer pays by check or charge, there is never change to give back. Oh and in the Check and Charge column, I place an "x" in it when it is used. So when the "x" is placed in that column that's when I want the Change column to input a 0.

Thanks for your help.

 

[data808]

Hey Robert,

tried the macro today. Everything worked great. You are a genius. Thanks so much. If I ever have any questions, I'll be sure to ask you, the Master. Thanks again.

 

[Trebor76]

If I ever have any questions, I'll be sure to ask you, the Master

Thanks for the kind words but I'm a student compared to some of the people here.

You should also start a new thread for each separate question to give yourself the best possible change of having it answered as well giving others to the opportunity to learn / have a similar problem solved.

 

[data808]

Hey Robert,

I was using that macro that you edited for me and it worked fine on Office 2010 but when I tried using it on Office 2003 there seems to be a problem. After experimenting for a while I realize that when "text" is entered into columns A through D then the current date is entered in column J fine. What I forgot to mention to you is that in column A and B, I type numbers here. Column A is just straight numbers 00-99. In column B, I type the time here and the cell is formatted to ##":"##. It enters the colon automatically. So when I type numbers into column A or B something gets messed up and freezes the spreadsheet because I think its expecting "text" or alpha letters here.

Also the formula you wrote to calculate the change to give back to the customer also freezes up the spreadsheet when I enter the Cash Given column. So first I enter the Amount Due and everything is fine, then when I enter the Cash Given and its about to calculate the Change that I have to give back, that's when it freezes.

Again, everything worked fine on Office 2010 with no problems. This is only happening on Office 2003 and I haven't tested it on Office 2007 yet. The computers in our office are using all different versions of Office which is very frustrating. Sorry to bother you again but I just can't seem to figure out whats wrong.

Thanks again for all your help.