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,
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,
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks