Thread: constants
View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
try
=$A$1*20

--
Regards
Frank Kabel
Frankfurt, Germany

"Confused" schrieb im Newsbeitrag
...
How to you keep a number constant in a formula on the next cell?

Example:
Formula on line A5
=sum(A1*20)
and I want the 20 to remain the same in the formula on the next

cell.

Thanks!