Try $B$2

wrote in message
...

On Tuesday, 29 January 2008 20:10:05 UTC+1, Mark wrote:
How can I copy the formula so that B2 stays constant and only the row
changes?

A B C

1 2

2 10 =A2*B1

3 20 =A3*B1

4 30 =A4*B1


Thanks

Very helpful - quickly solved a problem that I had never gotten round to
resolving. Thanks, so much!