First Problem is Spreadsheet

[Mike Rivera <ho...@yahoo.com.INVALID>]

Hi, I love your software but, I have encountered a problem with it. I use it as a budget spreadsheet and suddenly  one of the boxes that keeps my balance correctly does not do so... I've had to write in the amount  cause no matter what I do, it does not calculate correctly... Please reply if you have a remedy..
thank you,, Mike 
949-230-2045I use your software for everything..

Re: First Problem is Spreadsheet

["Howard Morris (aka Col Boogie)" <Ho...@hotmail.com>]

Sorry, I missed that.
I found your h15 with the hand entry. I erased that (via backspace) and copied h14 (ctrl +c) and pasted it (ctrl +v) to h15 and all was well.
This time I could not repeat your problem.

Howard

______________________________________________________________________________________________________

If you go to the bottom of sheet, you will 3 sections- first section is checking, next section is Savings, and last one is Budget.. You will find h15 in the Savings section..and I copied it to paste the formula and it still didn't work. Also, I deleted that row and tried it again and still didn't work...




On Monday, January 25, 2016 10:01 PM, Howard Morris (aka Col Boogie) <Ho...@hotmail.com> wrote:




Thank you,
  I am a bit confused. Your example shows “trf to chking”. I did not find that in the spreadsheet you sent me. However, I did a little testing. I did some testing anyway, and some curious things happened. Sometimes when I changes things, the value was not recalculated. However, when I copied pasted the BAL formula from the line above it, things were quickly fixed. I am sorry that this is just a workaround for your problem, but we will look deeper into it later.

Howard

Re: First Problem is Spreadsheet

["Howard Morris (aka Col Boogie)" <Ho...@hotmail.com>]

Thank you,
  I am a bit confused. Your example shows “trf to chking”. I did not find that in the spreadsheet you sent me. However, I did a little testing. I did some testing anyway, and some curious things happened. Sometimes when I changes things, the value was not recalculated. However, when I copied pasted the BAL formula from the line above it, things were quickly fixed. I am sorry that this is just a workaround for your problem, but we will look deeper into it later.

Howard

Re: First Problem is Spreadsheet

["Howard Morris (aka Col Boogie)" <Ho...@hotmail.com>]

Hi,
    I am not sure, but please check the ranges used in that box for the spread sheet.  You may have used sum(D2:Z2) and the data has extended beyond Z2. While I do not know of a maximum number of things that can be added, etc., You may also try sum of the first so many things and use that value as part of another sum.
    Howard Morris

PS. It would be easier for us if you sent a copy of the spreadsheet and tell us which cell you are getting erroneous results.