Range maths function

cwng3

New Member
Joined
Nov 7, 2005
Messages
31
Hi,

I want to mulitiple each element in the range by 100. How can I do it ?

I want to see if any way to avoid looping.

Thanks

TT
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
Put 100 in a cell by itself.
Copy it.
Select the range of cells you want to multiply by 100.
Select Edit, Paste Special, Multiply.

You're done.

Hope that helps!
 

cwng3

New Member
Joined
Nov 7, 2005
Messages
31
Thank you. But is it the only way. I dont prefer to use copy/paste in marco.
 

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
That's the only way I can think of doing it without looping through each cell you select to multiply.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,272
Messages
5,577,133
Members
412,769
Latest member
VK12345
Top