Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
Tony, have you added a column? The original had 7, A-G. That¡¯s fine as long as you intended that. +1192 doesn¡¯t belong there. What is the formula in the balance cell above that? It should be H1179
By
Otto Nikolaus
·
#18626
·
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
That should not be there at all. The balance is simply previous balance + credit - debit. Otto
By
Otto Nikolaus
·
#18625
·
|
Sending text from MacBook Air to Android phones
Sending text messages through Messages on my MBA didn¡¯t used to be a problem, and I can¡¯t discern when it became one. I have, of course, scoured the forums for answers/solutions/fixes, and
By
Debbi
·
#18624
·
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
There should be a letter before 1192 in the formula. cjc
By
Christopher Collins
·
#18623
·
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
Click on the cell with the correct formula, If you then place the cursor into the next cell (in this case below it), it should look like this (with different numbers of course): ? Drag that yellow
By
Jim Saklad
·
#18622
·
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
The last line that worked shows this as Formula: H1180+Credit(Date)-Debit(Date)+1192. the next line under that & all lines after no Formula appears. That is what I do not know how to fix. Tony M
By
Tony M
·
#18621
·
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
Each cell in the Balance column needs to contain a formula. Place the cursor on the last one that works correctly and you will see that formula in the bar at the bottom of the table. Copy that cell
By
Otto Nikolaus
·
#18620
·
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
It is a simple check: Click on the cell in question Look at the ¡°edit line¡± at the bottom, which shows what is in the cell. That SHOULD show the calculation formula ¨C if so, is that formula
By
Jim Saklad
·
#18619
·
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
It did not work. Since the beginning of using the spreadsheet, I have always added line below the last line and it always continued to correctly reduce or increase the balance accordingly. I tried
By
Tony M
·
#18618
·
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
I¡¯m concerned that Tony hasn¡¯t replied to this. I¡¯d like to know that the spreadsheet is now working correctly; if not, I¡¯ll try to see what the problem is. The download at
By
Otto Nikolaus
·
#18617
·
|
Re: Easyfind - is it still available?
Just downloaded this the other day. https://www.devontechnologies.com/apps/freeware Thanks to Randy¡¯s free software page by the way. http://www.macattorney.com/free.html Cheers, Tod
By
todhop
·
#18616
·
|
Re: Easyfind - is it still available?
On the devontechnologies.com <http://devontechnologies.com/>, click Apps > Needful Things. David
By
David Brostoff
·
#18615
·
|
Easyfind - is it still available?
I wanted to add Easyfind to my newest Mac but can¡¯t find it. The App Store shows easy funder 2. According to the easy find info on my other Mac it is a Devon technologies app. I don¡¯t see it on
By
Bob Stern
·
#18614
·
|
No More 27-inch iMacs
Apple Confirms No More 27-inch iMacs "Apple PR representative Starlayne Meza confirmed the company¡¯s plans to The Verge. The company encourages those who have been holding out hope for a larger iMac
By
Randy B. Singer
·
#18613
·
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
(I can¡¯t believe I set this up over a year ago!) Yes, when you add a new row, you *must* copy the Balance cell from above as it contains the formula to update that balance. It¡¯s easy to rectify
By
Otto Nikolaus
·
#18612
·
|
No More 27-inch iMacs
Apple Confirms No More 27-inch iMacs "Apple PR representative Starlayne Meza confirmed the company¡¯s plans to The Verge. The company encourages those who have been holding out hope for a larger iMac
By
Randy B. Singer
·
#18611
·
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
It sounds like you are working beyond the range of formatted cells. Brent
By
Brent
·
#18610
·
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
I have been using this spreadsheet as a checking account balance and it has been working fine for over a year but today all of a sudden when I place a Debit charge it isn¡¯t reducing the balance to
By
Tony M
·
#18609
·
|
Re: Newest AirPods Pro
I have, but even though my hearing isn¡¯t what it used to be, I can tell that Herr Mahler would be far more impressed if he could hear what I hear through the AirPods Pro than what I can hear though
By
jimrobertson
·
#18608
·
|
Re: Newest AirPods Pro
Have you considered that your 70-odd-year-old ears may not be capable of hearing the difference? Jim Robertson wrote:
By
Jim Saklad
·
#18607
·
|