#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default formulas in excel

Help I need a formula! I have a check book register that I use for my
business, at the top of the page in cell I2 I need to display the balance and
make it update when I enter new checks.

A B C D E F G H I
J K
1 New Balance
2
3
4
5 Balance
6 New Balance Update I2

Any help would be great

Thanks


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 695
Default formulas in excel

hmm. not much to work with :-)

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default formulas in excel

You might simply link I2 to the cell containing your balance totaling
formula.

If your formula is in I6, then try this in I2:

=I6

OR,
You could place your actual totaling formula in I2 outright:

=SUM(I3:I5)

If this *doesn't help, post back with additional information.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Wildmandt" wrote in message
...
Help I need a formula! I have a check book register that I use for my
business, at the top of the page in cell I2 I need to display the balance

and
make it update when I enter new checks.

A B C D E F G H I
J K
1 New Balance
2
3
4
5 Balance
6 New Balance Update I2

Any help would be great

Thanks



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel considers my formulas as plain text Kimmo Kallio Excel Worksheet Functions 10 January 16th 14 05:48 PM
How do you print showing formulas in Excel 2000? Kim Excel Discussion (Misc queries) 3 June 16th 08 09:56 PM
Please help with Statistics Formulas in Excel Fonz Excel Discussion (Misc queries) 10 April 9th 06 03:22 PM
Help, Urgent Excel Formulas are not calculating maashoff Excel Discussion (Misc queries) 1 May 3rd 05 12:25 AM
I want Excel to allow cells with formulas and unrelated text blueboy Excel Discussion (Misc queries) 9 March 4th 05 12:22 AM


All times are GMT +1. The time now is 06:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"