Thread
:
multiply
View Single Post
#
5
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
multiply
calculation set to manual?
--
Don Guillett
SalesAid Software
"jackievar" wrote in message
...
Each column has a different number to multiply by .07. I can't figure out
how to copy down to get it to do each number differently. It keeps
putting
the first total in all columns.
"Don Guillett" wrote:
If I understand you, you have a column of numbers that you want to keep
and
you want to create a column of numbers which is the first column
multiplied
by 7c. Can't you use simple =a2*.07 and copy down?
--
Don Guillett
SalesAid Software
"jackievar" wrote in message
...
I'm trying to multiply a word count in 50rows by $.07. I've put .07 in
random cell, copy, select word count column, paste special then it goes
to
a
box that says: Paste Special, either Unicode text or text.
When I did get it to multiply once, it covered the word count column
and I
didn't know how to get it into the Total column. I have to show both
columns.
Help!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett