View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GJones GJones is offline
external usenet poster
 
Posts: 132
Default Copy formula without changing all values


sweath;

use !

-----Original Message-----
I would like to copy a formula to several cells=(B197-

$B198)/$B198 . I want the B198 to stay the same and the
B197 to change as the formula is moved. I thought the
$(dollar sign) would make the B198 stay, but it is
changing as I copy. How do I make the B198 stay the same.
.