+ Reply to Thread
Results 1 to 3 of 3

how to select a certain range and multiply it wih a certain value

  1. #1
    Registered User
    Join Date
    03-27-2005
    Posts
    12

    how to select a certain range and multiply it wih a certain value

    I want to select data from 4 cols and 150 rows(S1:V150) and then mutliply each cell value with .89.
    Does anyone know how I can do it?

    Thanks,

  2. #2
    Registered User
    Join Date
    03-09-2005
    Posts
    9
    You could type .89 into a cell. Then copy it. Select all the data you want to multiple and do a paste special -> under operation you can select multiply.

    This should do it for you.

  3. #3
    Registered User
    Join Date
    03-27-2005
    Posts
    12
    Sorry My mistake. I forgot to write that I want it in a macro as the value to be multiplied is not static. It is based on user input.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1