Results 1 to 4 of 4

Thread: Request for Help with Function.

  1. #1

    Question Request for Help with Function.

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


    I am looking to fetch a value in C1 based on A1, B1 AND D1

    Condition 1:
    A1 = "A" (Text)
    B1 = "X" (Text) then 7% OR Minimum 7
    B1 = "Y" (Text) then 20%

    Condition 2:
    A1 = "B" (Text)
    B1 = "X" (Text) then 10% OR Minimum 10
    B1 = "Y" (Text) then 40%

    IF A1="A" AND B1="X" Then C1=(D1*7%) But if the Value returned in C1 is <=7 then C1 should have minimum value 7, Else the returned value.

    I need to add minimum criteria in my below function, Can you help me on this.
    =IF(AND(A1="A",B1="X"),D1*7%, IF(AND(A1="A",B1="Y"),D1*20%, IF(AND(A1="B",B1="X"),D1*10%, IF(AND(A1="B",B1="Y"),D1*40%))))

  2. #2


    But what happens if none of the above are met?

  3. #3
    An alternative


  4. #4

    Thank you so much, Both functions works, I would rather use the alternative one so that my function length becomes shorter
    I have only two Variables in both A & B, I have used drop down box with those value. Hence there cannot be any other value or condition.

    Again Thank you so very much.....

Posting Permissions

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