+ Reply to Thread
Results 1 to 2 of 2

I need help to multiply a column with values by 180% & then ROUNDUP to 1 decimal

Hybrid View

RobinPrice I need help to multiply a... 01-04-2014, 06:04 AM
jindon Re: I need help to multiply a... 01-04-2014, 06:21 AM
  1. #1
    Forum Contributor
    Join Date
    12-27-2013
    Location
    Perth
    MS-Off Ver
    Excel 2010
    Posts
    102

    I need help to multiply a column with values by 180% & then ROUNDUP to 1 decimal

    Hi all,
    The column H has numbers in it I need a macro to multiply the values in H (H*180%) & then ROUNDUP the result to one decimal point

    Thanks a Million
    Karl

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: I need help to multiply a column with values by 180% & then ROUNDUP to 1 decimal

    One way
    Sub test()
        With Range("h1", Range("h" & Rows.Count).End(xlUp))
            .Value = Evaluate("if(" & .Address & "<>"""",if(isnumber(" & _
            .Address & "),round(" & .Address & "*1.8,1)," & .Address & "),"""")")
        End With
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to multiply a range of values without creating a new column
    By BNCOXUK in forum Excel General
    Replies: 4
    Last Post: 08-01-2012, 04:14 AM
  2. Multiply by only the decimal
    By mamann in forum Excel General
    Replies: 7
    Last Post: 12-20-2010, 01:46 PM
  3. The Formula to Multiply Decimal in Excel
    By antoni in forum Excel General
    Replies: 8
    Last Post: 11-29-2008, 01:05 AM
  4. Replies: 2
    Last Post: 04-01-2006, 12:47 AM
  5. Roundup Decimal
    By Kitty in forum Excel General
    Replies: 2
    Last Post: 01-04-2006, 11:20 AM

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