Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
Trouble with a formula in Numbers
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="filmhandler" data-source="post: 1767179" data-attributes="member: 395049"><p>So i have made this spreadsheet that tracks daily deposits, and when the file was in excel, I had a formula that made predictions of what the bank balance would be up to a week in the future. Now that I'm in Numbers, and I don't have a excel on my mac, that formula doesn't work. I need help to find a way to make the formula work, or a formula that will work.</p><p></p><p>the formula is this;</p><p></p><p>=if(B3=$A$1, $A$2 + C3, D9 + C3)</p><p></p><p>A1 has the formula for date of =NOW() and is formatted for Days of the week, Sunday - Saturday.</p><p>B3 through B9 are the days of the week</p><p>A2 is the current daily Balance</p><p>C3 through C9 is the Average daily deposit</p><p>D3 through D9 are the formula above copied and pasted so that the appropriate cells are referenced.</p><p></p><p>Can anyone help.</p></blockquote><p></p>
[QUOTE="filmhandler, post: 1767179, member: 395049"] So i have made this spreadsheet that tracks daily deposits, and when the file was in excel, I had a formula that made predictions of what the bank balance would be up to a week in the future. Now that I'm in Numbers, and I don't have a excel on my mac, that formula doesn't work. I need help to find a way to make the formula work, or a formula that will work. the formula is this; =if(B3=$A$1, $A$2 + C3, D9 + C3) A1 has the formula for date of =NOW() and is formatted for Days of the week, Sunday - Saturday. B3 through B9 are the days of the week A2 is the current daily Balance C3 through C9 is the Average daily deposit D3 through D9 are the formula above copied and pasted so that the appropriate cells are referenced. Can anyone help. [/QUOTE]
Verification
Name this item 🌈
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
Trouble with a formula in Numbers
Top
