Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Conditional Formula || IF AND HELP!!!

  1. #11
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,312
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ok I think I follow you now

    Where A2 = 95% (the listed goal) and B2 = the InputValue:

    =IF(B2>=A2,100%,B2)

    Should cover it,
    Adam

  2. #12
    Board Regular zacemmel's Avatar
    Join Date
    Apr 2002
    Location
    Redmond, WA
    Posts
    636
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    So, you just want to return the corresponding value?

  3. #13
    New Member
    Join Date
    Apr 2002
    Location
    C Hawk
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    All of my IM stuff is on if that is easier.

    I need it to say all the different outcomes in one cell. Meaning if goal is < 95% then payout is 100% =>94 = 94, =>93 = 93 and on down the line

    So more than just one outcome is what I am getting at...

Some videos you may like

User Tag List

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
  •