| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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:) |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Making custom templates with formulas
Enter your column headings in Row1
Then type this in D2 and press ENTER =C2*5 It will show 0 till you enter something in C2. To avoid that you can use =IF(C2="","",C2*5) Similary enter in F2 =C2+D2 which is same as =C2*6 since D2 is five times C2 You can copy these down Col C and D or "MG" wrote: 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:) |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Making custom templates with formulas
Thank you Sheeloo...I am going to go giv it a whirl...I am excited!!woohoo!
-- MG:) "Sheeloo" wrote: Enter your column headings in Row1 Then type this in D2 and press ENTER =C2*5 It will show 0 till you enter something in C2. To avoid that you can use =IF(C2="","",C2*5) Similary enter in F2 =C2+D2 which is same as =C2*6 since D2 is five times C2 You can copy these down Col C and D or "MG" wrote: 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:) |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Making custom templates with formulas
Thank you Sheeloo it worked like a dream...I made two templates with
functions and I'm on a roll. You've made my like a whole lot sweeter.Thank you very much. -- MG:) "MG" wrote: Thank you Sheeloo...I am going to go giv it a whirl...I am excited!!woohoo! -- MG:) "Sheeloo" wrote: Enter your column headings in Row1 Then type this in D2 and press ENTER =C2*5 It will show 0 till you enter something in C2. To avoid that you can use =IF(C2="","",C2*5) Similary enter in F2 =C2+D2 which is same as =C2*6 since D2 is five times C2 You can copy these down Col C and D or "MG" wrote: 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:) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to save formulas when creating templates | Excel Discussion (Misc queries) | |||
| custom lists and custom formulas? | Excel Discussion (Misc queries) | |||
| How do I use formulas and what is the secret to making them | New Users to Excel | |||
| Automatically making formulas "Absolute" or "$ Relative" | Excel Discussion (Misc queries) | |||
| Saving templates with links and formulas | Excel Discussion (Misc queries) | |||
Linear Mode
