formula help
Results 1 to 4 of 4

Thread: formula help
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2011
    Posts
    78
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default formula help

    HI

    I am having issues doing an if statement , i seem to get the wrong end result, below is the data i have

    A
    1 0.48
    2 -
    3 0
    4 1

    now when i do this formula below i should get 175 but for some reason i get 75

    =IF(A1="-",0,(IF(A1>0.5,100,IF(A1>0.4,75,IF(A1>0.3,50,0)))+IF(A2="-",0,IF(A2>0.1,100,IF(A2>0.07,75,IF(A2>0.05,50,0)))+IF(A3="",0,IF(A3>4999,100,IF(A3>3999,75,IF(A3>1000,50,0)))+IF(A4="",0,IF(A4<6,100,IF(A4<11,75,IF(A4<15,50,0))))))))

    can anyone help please?

  2. #2
    Board Regular tyija1995's Avatar
    Join Date
    Feb 2019
    Posts
    581
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    4 Thread(s)

    Default Re: formula help

    Hey try this:

    =IF(A1="-",0,IF(A1>0.5,100,IF(A1>0.4,75,IF(A1>0.3,50,0))))+IF(A2="-",0,IF(A2>0.1,100,IF(A2>0.07,75,IF(A2>0.05,50,0))))+IF(A3="",0,IF(A3>4999,100,IF(A3>3999,75,IF(A3>1000,50,0))))+IF(A4="",0,IF(A4<6,100,IF(A4<11,75,IF(A4<15,50,0))))
    √-1 2³ ∑ π
    …And it was delicious!

  3. #3
    Board Regular
    Join Date
    Mar 2011
    Posts
    78
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula help

    thank you, why was mine not working?
    Quote Originally Posted by tyija1995 View Post
    Hey try this:

    =IF(A1="-",0,IF(A1>0.5,100,IF(A1>0.4,75,IF(A1>0.3,50,0))))+IF(A2="-",0,IF(A2>0.1,100,IF(A2>0.07,75,IF(A2>0.05,50,0))))+IF(A3="",0,IF(A3>4999,100,IF(A3>3999,75,IF(A3>1000,50,0))))+IF(A4="",0,IF(A4<6,100,IF(A4<11,75,IF(A4<15,50,0))))

  4. #4
    Board Regular tyija1995's Avatar
    Join Date
    Feb 2019
    Posts
    581
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    4 Thread(s)

    Default Re: formula help

    Your parenthesis were misplaced, so the nesting was incorrect, easy to do when using multiple IF functions
    √-1 2³ ∑ π
    …And it was delicious!

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
  •