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.

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

There are 3 options when using Absolute references -the $ sign.

In your case all you have locked is the column - $B198

To lock the complete formula it is written as $B$198

or to lock only the row number it would be B$198

If you select the element B198 and then press F4 yo can cycle betwee
thos 3 options with the fourth option removing all dollar signs

HT

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements