How to copy formula with one cell constant
 

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

How to copy formula with one cell constant
 

Put this formula in B2:

=A2*B$1

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

Hope this helps.

Pete

On Jan 29, 7:10*pm, 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

How to copy formula with one cell constant
 

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

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

How to copy formula with one cell constant
 

Dear pete_uk,

Thanks a ton,

saved lot my time and appricate your effort on this.
Regards,
Dr. Shashi
www.holidaymantra.com
On Wednesday, January 30, 2008 12:52:15 AM UTC+5:30, Pete_UK wrote:
Put this formula in B2:

=A2*B$1

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

Hope this helps.

Pete

On Jan 29, 7:10*pm, 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

How to copy formula with one cell constant
 

On Tuesday, January 29, 2008 2:10:05 PM UTC-5, 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

GOOD JOB GUYS

How to copy formula with one cell constant
 

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!

How to copy formula with one cell constant
 

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!