View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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!