Multiply range with constant and round results

**ciprian** · 06-06-2011, 04:38 AM

Hi guys, I need a macro that will multiply all cells in a column and round the results.

For example,

A1:A30 is the range

Constant is found in A33

All cell in the range will be multiplied with A33 and the result should be rounded (it will be an int number). The result will overwrite the initial cell.

Thanks for the help

**snb** · 06-06-2011, 04:45 AM

    [A1:A30] = [index(int(A1:A30*A33),)]

**ciprian** · 06-06-2011, 04:52 AM

thank you for the quick reply snb, but unfortunately I don't know how to use that

**Richard Buttrey** · 06-06-2011, 04:55 AM

Hi,

..or another approach

Range("A33").Copy
Range("A1:A30").PasteSpecial Paste:=xlPasteAll, Operation:=xlMultiply

**ciprian** · 06-06-2011, 04:58 AM

Range("A33").Copy
Range("A1:A30").PasteSpecial Paste:=xlPasteAll, Operation:=xlMultiply

this part i know, managed to do it with record macro

normally it would be

 =ROUND((A1*A33);0)

but this would mean the result is in a different cell

Thread: Multiply range with constant and round results

Thread Tools

Display

Multiply range with constant and round results

Re: Multiply range with constant and round results

Re: Multiply range with constant and round results

Re: Multiply range with constant and round results

Re: Multiply range with constant and round results

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions