Hi.
I hava table 4x10.. ok.
I use this formula:
IF (TABCATEGORIA.$A5 = "A+" & TABCATEGORIA.$A6 = "B+"; "no"; "SI")
but not work. Is not possible use AND operator inside the function? And if not, how can I do ?
Regards.
Operator AND inside function
Re: Operator AND inside function
If you enclose the two conditions being tested by the "If" statement in brackets it should work.
so
if((Table1.#a1<5) & (Table1.#c3<5); "Small"; "Large")
should print "Small" or "Large" depending on the values in Table1. It did in my tests.
Lance
so
if((Table1.#a1<5) & (Table1.#c3<5); "Small"; "Large")
should print "Small" or "Large" depending on the values in Table1. It did in my tests.
Lance
Re: Operator AND inside function
Thank you LanceGary !
Now it works well.
Regards.
Now it works well.
Regards.