Expanding this formula
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Expanding this formula

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

    Default

     
    Hi All,

    I want to add extra condition to this statement, but having problems doing so.

    Standard formula
    =IF(G6<=2200,L10)
    This works fine, want to add IF(G6>2200,< 2500,L11) OR IF(G6>2500 <3000,L12)

    Any help is much appreciated..
    Ta
    Mike

  2. #2
    New Member
    Join Date
    Apr 2002
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try this:

    =IF(G6<=2200,L10,IF(G6<2500,L11,IF(G6<3000,L12,"")))

    You can embed up to 7 if statements. If you need more than that, there are ways around it by using more than one cell, each with your "maximum IF" equation, then a consolidation cell that sums the other cells containing your "maximum IF" equations. There are likely more efficient ways to do this, but since I don't know any better, I've found this works for me.

    Dale

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

    Default

    Thanks Dale,
    That works fine. I have a heap of work like that, thanks again.
    Mike

  4. #4
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-04-17 21:24, dpolson wrote:
    Try this:

    =IF(G6<=2200,L10,IF(G6<2500,L11,IF(G6<3000,L12,"")))

    You can embed up to 7 if statements. If you need more than that, there are ways around it by using more than one cell, each with your "maximum IF" equation, then a consolidation cell that sums the other cells containing your "maximum IF" equations. There are likely more efficient ways to do this, but since I don't know any better, I've found this works for me.

    Dale
    Hi Dale,

    Don't sell yourself short. Your response is *the* standard way to do this, and it is so for a reason -- because it is straightforward and it works (very well). Nobody will find a solution that is significantly more efficient.

    Nice job.

    Bye,
    Jay

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
  •  

 

 
DMCA.com