creating a "constant" number to be used in formulas

[Guest]

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!

 

[T. Valko]

Try this:

A2:A10 = hours worked
B1 = 25

Enter this in B2 and drag copy down to B10:

=A2*B$1

Biff

 

[SteveW]

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

 

[Bruce Sinclair]

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