Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: return a value based on several conditions...

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What I want is a value return if several conditions are met. If x < .25 then return 0. If x is between .299 and .399 then return .25...and so on. Is this possible?




    [ This Message was edited by: firebirdone on 2002-05-02 14:36 ]

    [ This Message was edited by: firebirdone on 2002-05-02 14:39 ]

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

    Default

    Hey,

    Sure thing. You can either use a nested if statement (up to 7 in one formula) or a vlookup.

    In your example:

    =IF(A2<0.25,0,IF(AND(A2>0.3,A2<0.4),0.25,IF(next criteria and so on ))

    I'd give you a better formula if I knew all your conditions.

    Hope that helps,
    Adam

  3. #3
    New Member
    Join Date
    May 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Let me try and I'll let you know. Thank you.

  4. #4
    New Member
    Join Date
    May 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you Asala42. It worked.

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
  •