How to copy formula with one cell constant

M

Mark

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
 
P

Pete_UK

Put this formula in B2:

=A2*B$1

When you copy this down the $1 will not change.

Hope this helps.

Pete
 
S

Stan Brown

Tue, 29 Jan 2008 11:10:05 -0800 from Mark
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

?? B2 ??
 
A

asad.ahmed.online

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

GOOD JOB GUYS
 
I

ianspringham

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!
 
W

wabbleknee

Try $B$2

wrote in message

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top