Three criteria using IF function resulting four results

[magsmon]

Good day everyone,

I have variables X and Y where the criteria follows:

if 1<X<4 and 1<Y<3, I want to present the text "well graded gravel", otherwise ""

if 4<X<6 and 1<Y<3, I want to present the text "well graded sand", otherwise ""

Now, I made this formula

=IF(OR(AND(F14>1, F14<4), AND(F15<3, F15>1)), "well graded gravel", " ")(OR(AND(F14>4, F14<6), AND(F15<3, F15>1)), "well graded sand", " ")

but it shows #REF! I tried Show Calculation Steps but still could not figure out what is wrong. Please help me.

Thanks in advance,
Mon

[AliGW]

Try this:

=IF(OR(AND(F14>1, F14<4), AND(F15<3, F15>1)), "well graded gravel", IF(OR(AND(F14>4, F14<6), AND(F15<3, F15>1)), "well graded sand", " "))

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[magsmon]

Thank you very much, it worked like charm!

[AliGW]

You're welcome!

It was just a case of getting the syntax right.