Check regester issues

[steveb1957]

My check register has stopped working properly. The formulas won't work together such as

<tbody>
[TD="class: xl67"][/TD]

</tbody>

=IF(AND(ISBLANK(F85),ISBLANK(G85)),"",H84-F85+G85)
=IF(AND(ISBLANK(F86),ISBLANK(G86)),"",H85-F86+G86)
These are from 2 total lines in my spreadsheet (ss) that works
Now
This next formula don't work
=IF(AND(ISBLANK(F7),ISBLANK(G7)),"",H6-F7+G7)
=IF(AND(ISBLANK(F8),ISBLANK(G8)),"",H7-F8+G8)

the 1st formula on the spreadsheet is a copy/paste-link from the bottom of the previous page
='Check Register (73)'!H89, i am on ss 74

if I could past a file to show you better what I'm talking about that would be great.

 

[sheetspread]

You know that "" will return false for isblank, whether pasted as a value or not, right?

 

[steveb1957]

You know that "" will return false for isblank, whether pasted as a value or not, right?

=IF(AND(ISBLANK(F7),ISBLANK(G7)),"",H6-F7+G7)
=IF(AND(ISBLANK(F8),ISBLANK(G8)),"",H7-F8+G8)

I replaced the "" with a 0 per another thread and the answer remained the same
when I clicked on the cell the formula was in & tried to copy it downward thru copy/paste & I tried dragging it down by the lower right corner of the cell
it didn't drag, it only copied the cell I was trying to drag. Could this be an issue going from excel 2007 to excel 365? If it is I wold gladly provide the file to anyone that thinks they can rewrite the code or give me a hint as to what to do. can you tell I'm sorta desperate? If no one can get to this before the 4th of July have a GREAT one!!!

 

[sheetspread]

Post the link to the file, I'll look at it. I don't have 365 though so if you're sure that's the problem hopefully someone else will be able to test.

 

[sheetspread]

You have to upload it to a host like dropbox or google and paste the link here

 

[steveb1957]

https://drive.google.com/drive/my-drive/checkregester.xlsx

if this don't work then I may need some help with google drive

 

[steveb1957]

Did I do something wrong? Isn't Google Drive where I was supposed to put the link?

 

[sheetspread]

It's not showing up when I click

 

[steveb1957]

If you'll allow me, I opened a new excel ss & went to the online templates. I did a search for Check Register, & found the exact template that I'm using as a regular ss. The formula in the Balance column in this template don't work either. I'm using excel 365, on a new windows 10 PC. Please try this template. I don't what else to do, & this is my only check register. Thanks again!

 

[steveb1957]

the name of the template is check register simple design 1