Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating a "constant" number to be used in formulas
i want to calculate a series of formulas in rows where all are based off a
standard number (ie: $25/hr times the various hours worked each day). at the moment i have a column with $25 pasted a million times to get a total sum in the next column, there has got to be a more efficient way than this to accomplish? thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating a "constant" number to be used in formulas
Try this:
A2:A10 = hours worked B1 = 25 Enter this in B2 and drag copy down to B10: =A2*B$1 Biff "tkg" wrote in message ... i want to calculate a series of formulas in rows where all are based off a standard number (ie: $25/hr times the various hours worked each day). at the moment i have a column with $25 pasted a million times to get a total sum in the next column, there has got to be a more efficient way than this to accomplish? thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating a "constant" number to be used in formulas
Well one way is to actually do that create a constant
Insert - Name - Define.. Put a name at the top ie "HourlyRate" at the bottom put =25 Click on Add Use in any cell or formula by name ie =HourlyRate =HourlyRate * A5 etc Steve On Tue, 13 Feb 2007 05:58:01 -0000, tkg wrote: i want to calculate a series of formulas in rows where all are based off a standard number (ie: $25/hr times the various hours worked each day). at the moment i have a column with $25 pasted a million times to get a total sum in the next column, there has got to be a more efficient way than this to accomplish? thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating a "constant" number to be used in formulas
In article , SteveW wrote:
Well one way is to actually do that create a constant Insert - Name - Define.. Put a name at the top ie "HourlyRate" at the bottom put =3D25 Click on Add An easier way to create the name is to click on the cell, then just type the name into the 'name box' (which usually shows the current cell). Best to use capital and small letters (I can't remember why but I think it has to do with name checking :) )and use _ instead of spaces. Use as before or just use the cell. IIRC, it will cleverly update the reference to the name :) Use in any cell or formula by name ie =3DHourlyRate =3DHourlyRate * A5 etc Steve On Tue, 13 Feb 2007 05:58:01 -0000, tkg = = wrote: i want to calculate a series of formulas in rows where all are based o= ff = a standard number (ie: $25/hr times the various hours worked each day). = at = the moment i have a column with $25 pasted a million times to get a total = = sum in the next column, there has got to be a more efficient way than this to= accomplish? thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
"lock" fields so they don't change number while copying formulas? | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |