LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
mg mg is offline
external usenet poster
 
Posts: 35
Default Making custom templates with formulas

Hello all.
I am new at Excel and have read most all the threads here and I believe this
is definitely the place for me to come for help.
Thank you in advance for any advice you may have for me.
I am trying to make up some templates where I will be able to use the same
formula repeatedly on a month to month basis.
Right now this is all Greek to me but I'm sure I can learn.
I have Excel 2000.
I'd like to set up a few different templates but am not sure how to enter
the formulas and save them.
First template I'd like to set up would be one with 7 columns and up to 50
rows.
Column A would be date
Column B would be a given invoice #.
Column C would be a given amount from an invoice.
Clolumn D would be column C times 5 percent
Column E would be an entered varying # or sometimes zero
Column F would be Column C plus column D
Is there a formula I could put in to these columns to do these functions?
I sure hope so !!! It would sure make my job easier.I have a few more
templates I would like to set up but I won't ask about them unless this is
even "doable"...
Thank you for any help.
MG:)
 
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
How to save formulas when creating templates JDV Excel Discussion (Misc queries) 4 July 29th 08 06:59 PM
custom lists and custom formulas? nameruc Excel Discussion (Misc queries) 0 December 6th 06 04:18 PM
How do I use formulas and what is the secret to making them eericclaptonfan New Users to Excel 6 July 26th 06 05:51 PM
Automatically making formulas "Absolute" or "$ Relative" JMATHES Excel Discussion (Misc queries) 4 August 27th 05 12:10 AM
Saving templates with links and formulas Barb1 Excel Discussion (Misc queries) 2 February 8th 05 04:13 PM


All times are GMT +1. The time now is 07:23 AM.

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

About Us

"It's about Microsoft Excel"