creating a "constant" number to be used in formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
Try this:

A2:A10 = hours worked
B1 = 25

Enter this in B2 and drag copy down to B10:

=A2*B$1

Biff
 
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
 
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
Click to expand...

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 :)
 
Back
Top