You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How to insert a new item into spreadsheet and have the balance correct?


Here is a partial view of a spread sheet I am currently using and am quite happy. However, I realized I forgot to add a couple of items between March 13 and March 18. If I add new rows where they should chronologically go, it seems to mess up the formula and the balance column no longer works. Is there an easy way to fix this so the formula will include the correct new balance after I add the two new items. I realize I could add them at the end but I really would like them to be chronologically correct when I submit this spreadsheet of purchases. Thank you for any help. I'm a Numbers newbie.

MacBook Air 13″, macOS 13.0

Posted on Dec 26, 2022 4:38 PM

Reply
Question marked as Top-ranking reply

Posted on Dec 26, 2022 6:00 PM

I assume the balance formula is something like cell G3 =G2-E3+F3. Replace it with

=OFFSET(G3,-1,0)-E3+F3

This way it will always refer to the cell directly above it.

Similar questions

2 replies

How to insert a new item into spreadsheet and have the balance correct?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.