Thread
:
NUB Formula Question
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_3_]
external usenet poster
Posts: 1,104
NUB Formula Question
Use =A1*$B$1
The $ can be typed or added using the F4 key
Look in Help for "absolute reference"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Dax Arroway" <Dax
wrote in message
...
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
Reply With Quote
Bernard Liengme[_3_]
View Public Profile
Find all posts by Bernard Liengme[_3_]