Results 1 to 2 of 2

Thread: adding Percentage
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Dec 2018
    Posts
    51
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default adding Percentage

    Hello,

    In the formula below how do i add IF 7% or lower make 0%?

    =IFERROR(VLOOKUP(B$1,OFFSET(INDEX($K$2:$K$900,MATCH($A2,$K$2:$K$900,0)),,,MATCH("*",INDEX($K$2:$K$900,1+MATCH($A2,$K$2:$K$900,0)):$K$900,0),2),2,0),"")

  2. #2
    Board Regular
    Join Date
    Nov 2008
    Location
    Netherlands
    Posts
    3,452
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: adding Percentage

    =IFERROR(if(VLOOKUP(B$1,OFFSET(INDEX($K$2:$K$900,MATCH($A2,$K$2:$K$900,0)),,,MATCH("*",INDEX($K$2:$K$900,1+MATCH($A2,$K$2:$K$900,0)):$K$900,0),2),2,0)>0.07,VLOOKUP(B$1,OFFSET(INDEX($K$2:$K$900,MATCH($A2,$K$2:$K$900,0)),,,MATCH("*",INDEX($K$2:$K$900,1+MATCH($A2,$K$2:$K$900,0)):$K$900,0),2),2,0),0),"")
    Short Guide to Better VBA - Link: https://www.mrexcel.com/forum/showthread.php?t=712119

    Please use code tags around your code:
    [Code] Your code here... [/Code]




    Engelse lessen, persoonlijk en doelgericht. Dutch tuition tailor-made for you. https://Ennef.nl

    Wearable for people with panic attacks: sidjup https://sidjup.com

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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