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!
|