a forumla

  • Thread starter Thread starter billrebels4
  • Start date Start date
B

billrebels4

helloi everyone:

because i have gotten so much help on here before, THANKS, i wanted to
give all you excel experts another problem to solve..

i have a spreadsheet that i am trying to format to make something like
a check register... i need the blance column to either subtract from
column e or add from column f and then add it to my balance. i though
about using a template but i am on a MAC (DONT HATE ME, I DO GRAPHICS)
but i do run office X for mac so windows templates wont work.


Thanks again for all the help....

BR4
 
The file format is the same for windows excel and mac excel..
Meaning someone with a mac can email an excel spreadsheet to someone
with windows excel and it can be used by both.
 
the template i downloaded from microsoft was not compatible with excel
X. I tried it and then looked back at the website and it said it would
not work on a MAC... thanks for the help... IT was worth a try... BR4
 
If it isn't compatible it would be pretty easy to make it compatible,
the file format is the same, there might be a slight difference with some
macros
and the date system but I am sure if you post this in the excel mac group
there are people who could tell
you what to change.. I guess you have to get a newsreader and post in a
usenet group instead of being linked
from a web interface forum.. Believe me, the file format is the same, do you
have the link to the template?
 
Assuming your running balance is in column G and you are starting in row 3

=G2-E3+F

You don't need any IF statement becuase your cridits and debits are in different columns

Good Luck
Mark Graesse
(e-mail address removed)

----- billrebels4 wrote: ----

helloi everyone

because i have gotten so much help on here before, THANKS, i wanted t
give all you excel experts another problem to solve.

i have a spreadsheet that i am trying to format to make something lik
a check register... i need the blance column to either subtract fro
column e or add from column f and then add it to my balance. i thoug
about using a template but i am on a MAC (DONT HATE ME, I DO GRAPHICS
but i do run office X for mac so windows templates wont work.


Thanks again for all the help...

BR
 
Back
Top