moderated Re: Need help with an Excel formula

Glenn / Lenny

Hi Shirley,
I find it easiest to just copy the contents of the cell with the formula and pasting it elsewhere.
So I would have both spread sheets open, and go to the cell where the formula works, and do control + C to copy, and control + tab to the other spreadsheet and move to where you want the formula, and paste it with control + V.

----- Original Message -----
Sent: Sunday, September 15, 2019 2:11 PM
Subject: Need help with an Excel formula

Hi Listers,


First, I do not fully know how to use Excel like many of you who probably use it for work. But I do use it for keeping our Writers Club’s roster and my bank account spread sheets. I used to have a formula that I could use in keeping a spread sheet of my bank debits and deposits—balancing my account. The formula I was given was =(E3-D3)+F2 and it helped me keep account of the totals when putting in debits and credits. Used to work great. Now, however, when I start a new monthly spread sheet, I get a message that the formula I key in is an error. I don’t know if something has gotten erased from the formula I had in my original file, or if the formulas have changed over time. Otherwise, I have no need to learn Excel. Can someone just please help me with this formula or tell me what might be wrong?


Thank you.







Join to automatically receive all group messages.