Thread
:
Dragging and Dropping Formulas
View Single Post
#
2
Posted to microsoft.public.excel.misc
Chip Pearson
Posts: n/a
Dragging and Dropping Formulas
Mike,
Try,
=A$1*B1
and copy down as far as you need to go.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Mike Bunch" <Mike
wrote in
message
...
I want A1 (for example) to always be multiplied with a list of
#'s in column
B with the results in column C. Is that clear? A1 should be
multiplied by B1
thu B20 with the sum showing up in C1 thru C20. Currently my
settings are
allowing the first part of the formula (A1) to increase to one
cell,
A2,A3,A4, and so on as you drag. Please Help????
Reply With Quote