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