Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Percentage.... (2000 sr 1)

    i have this 2 cells:
    ELENCO.Range("I" + RIGA2) = Trim(Sess0.SCREEN.GetString(I, 74, 14))
    ELENCO.Range("J" + RIGA2) = Trim(Sess0.SCREEN.GetString(I, 90, 14))
    how to calculate the percentage in
    ELENCO.Range("L" + RIGA2) =

    assuming cell in column I is= 8.018,28
    and in cells column J is=6.244,72

    tell me wich format in cell L i can use
    Tks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Percentage.... (2000 sr 1)

    Do you want to calculate column I as a percentage of column J, or column J as a percentage of column I?

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Percentage.... (2000 sr 1)

    sorry....
    column J as a percentage of column I

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Percentage.... (2000 sr 1)

    ELENCO.Range("L" & RIGA2) = ELENCO.Range("J" & RIGA2) / ELENCO.Range("I" & RIGA2)
    ELENCO.Range("L" & RIGA2).NumberFormat = "0%"

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Percentage.... (2000 sr 1)

    TKS!

Posting Permissions

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