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.
HTH.
Glenn

----- 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.

 

Shirley

 

 

 

 

Join main@jfw.groups.io to automatically receive all group messages.