Results 1 to 3 of 3

Thread: Help with a simple formula

  1. #1

    Help with a simple formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I THINK what I want is pretty simple I just can't find anywhere that will help me.

    If Column A is over $10 it will have an order qty of 3
    BUT If Column A is $20 it will have an order qty of 2
    BUT If Column A is over $50 it will have an order qty of 1

    So I want excel to be able to distinguish the 3 or 4 levels of pricing and work out that if it is within a certain threshold then it equals a certain order qty.

    help?

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    Assume order Qty. coloum is B

    Try:
    =IF(AND(A:A>10,A:A<=20),3,IF(AND(A:A>20,A:A<=50),2,IF(A:A>50,1,0)))

    copied down

  3. #3
    =if(a1>50,1,if(a1=20,2,if(a1>10,3)))

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •