Thread: How to copy formula with one cell constant
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] asad.ahmed.online@gmail.com is offline
external usenet poster
  
Posts: 1
Default 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
Reply With QuoteReply With Quote