Copy Formula

[Carter]

I am trying to copy a formula to multiple cells. How can
I copy a formula and the cell reference not change?

Example: =If(A235=B235,"True","False")

I want to copy this formula to preceeding cells and the
A235=B235 not change.

 

[Frank Kabel]

Hi
use:
=If($A$235=$B$235,"True","False")

See: http://www.cpearson.com/excel/relative.htm
for explaining this