Combining Three Separate Formulas

[artiststevens]

Hello,
I need help combining three separate formulas into one. The formulas are listed below.

If the value is equal the result is an empty cell.

Please Login or Register  to view this content.

If the value is greater than for the first formula proceed to the next formula, if it’s less than or equal to then either V30842 or an empty cell.

Please Login or Register  to view this content.

If the value is less than for the first formula proceed to the next formula, if it’s greater than or equal to then either V30842 or an empty cell.

Please Login or Register  to view this content.

Thanking you in advance for any and all help you can provide.

[6StringJazzer]

You have syntax errors in all of the above formulas. I will guess at what you really mean.

Note that you do not an explicit test for R30850<S30850 at the end because you have already checked for = and > so < is the only possibility left.

Please Login or Register  to view this content.

[artiststevens]

Hello StringJazzer,
Thank you for taking the time to assist me with this problem. I appreciate you taking a shot at guessing what I meant but doesn't quite work in some instances. let me try to expalin it better.

The following code is the original code.

Please Login or Register  to view this content.

Now all I want to do is add the following.

Please Login or Register  to view this content.

[6StringJazzer]

The condition in your second formula is unrelated to the conditions in your first formula. Do you want the condition in the second formula to be evaluated if neither of the conditions from your first formula is TRUE?


BTW an alternative way to write the first formula is

Please Login or Register  to view this content.

Note that in your formula and mine, if the condition is false you will see FALSE returned.

[artiststevens]

Thank you very much StringJazzer I was able to get it to work.

[6StringJazzer]

You're welcome! Thanks for the rep, and thanks for marking your thread Solved!