Formula to Compare A Value Against 2 Others

Put this formula in A30:

=IF(A1<A21,A1,IF(A1<A22,A20,0))

Hope this helps.

Pete

Hello,

Just fixed the semicolons needed and it yielded correct results PLUS I got to learn the logic behind it.

=EĞER(A1<A21; A1; EĞER(A1<A22; A20; 0))

("eğer" = "if" in Turkish)

Thank you very much.

You're welcome, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete

Hello,

May I add one more condition to the rule above or would it be too much for the formula to handle?

Let's add one more value to the set of positive integers our initial "x" is compared to.

"z" is the lower threshold of this set of numbers which was entered in the cell A19. So the final set would be in this order: z < a < b < c (cell-wise: A19 < A20 < A21 < A22)

The new condition is: When "x" is lower than "z", type "x" in A30 as the output AND type "x" (as a string) in cell A40.

Would that be too much of a cascade for the formula?

Thanks.

Would that work? I looked up a few things to come up with a solution myself:

=EĞER(A1<A21; EĞER(A1<A19; A1, AND(TYPE(A40,"x"); A1); EĞER(A1<A22; A20; 0))

You can't have a formula in A30 which "pushes" a value to A40 - you would need a formula in A40 instead, as well as the formula in A30. I would suggest the following in the cells stated:

A30: =IF(A1<A19,"x",IF(A1<A21,A1,IF(A1<A22,A20,0)))

A40: =IF(A1<A19,"x","")

Obviously, change the commas ( , ) to semicolons ( ; ) and use EĞER instead of IF.

Hope this helps.

Pete

Thank you!