NUB Formula Question

D

Dax Arroway

How do you got part of the formula to stay and the other part of the formula
to change when using the drag down handle?

For example:
I have
A1=<data> B1=12 C1=(A1*B1)

When I pull the handle down currently, I get:
=(A2*B2)
=(A3*B3) etc.

I'd like:
=(A2*B1)
=(A3*B1)
=(A4*B1)

How do I get the B1 to not change?

Thanks in advance for your help!
--Dax
 
B

Bernard Liengme

Use =A1*$B$1
The $ can be typed or added using the F4 key
Look in Help for "absolute reference"
best wishes
 

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

Similar Threads

multiplication of two array in a particular way 2
Lookup / Summary Table 8
how to use if formula in list (data validation list) 1
Complex IF formula 4
Controlling which parameteres change in fill functions 2
How do i keep it like this, A1:c1/b1, A2:c2/b1, A3: c3/b1? 4
Excel functions 0
Prob an easy one: How do i copy a formula EXACTLY as it is 9

Top