Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 983
Default Multiply a Range by a Constant

I would like to multiply a range by a constant. My range is Target

Target.value = [Target.value] * sngPercent

is what I have but it doesn't work. Any suggestions besides traversing the
range one element at a time?

Thanks In Advance...

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW DO I MULTIPLY MANY CELLS BY A CONSTANT CELL ? FROGGYDOLLY Excel Discussion (Misc queries) 13 April 27th 23 11:48 AM
Multiply a co;omn by a constant Q Excel Worksheet Functions 2 February 20th 10 09:54 PM
is it possible to multiply whole of excel table by some constant vijaya reddy Excel Discussion (Misc queries) 2 December 4th 07 12:05 PM
can i multiply digits of a number by a constant in excel? El Criollo Excel Discussion (Misc queries) 3 December 7th 06 01:18 PM
Multiply by a constant flotowntiger Excel Discussion (Misc queries) 3 December 6th 04 10:42 PM


All times are GMT +1. The time now is 12:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"