Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: IF formulas

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

    Default

    I am fairly new to Excel IF formulas and need help in displaying a result in one cell depending on the value in another cell. Something I am sure should be easy to do but I cannot get it to work.

    Eg if A1 is greater or less than 10 display 100. If A1 is => than 50 multiply A1 by 25, If A1 is => than 100 multiply by 20 If A1 is =>250 multiply by 17

    Would much appreciate some guidance on this.
    Thanks in advance

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey there, try this:

    =IF(A1>=250,A1*17,IF(A1>=100,A1*20,IF(A1>=50,A1*25,IF(A1=10,10,100))))

    Hope it's what you want


  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-17 04:28, chrisj wrote:
    I am fairly new to Excel IF formulas and need help in displaying a result in one cell depending on the value in another cell. Something I am sure should be easy to do but I cannot get it to work.

    Eg if A1 is greater or less than 10 display 100. If A1 is => than 50 multiply A1 by 25, If A1 is => than 100 multiply by 20 If A1 is =>250 multiply by 17

    Would much appreciate some guidance on this.
    Thanks in advance
    Chris, your specification is ambiguous...

    1. If A1 <> 10 then display 100
    2. If A1 >= 50 then A1*25
    3. If A1 >= 100 then A1*20
    4. If A1 >= 250 then A1*17

    Okay, suppose A1 is 250. All 4 of the above conditions are TRUE! What should be displayed? 100? A1*25? A1*20? A1*17?

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
  •