And - Or conditional statements

Posted by skt on November 14, 2000 9:01 AM

How do I do conditional expressions using "and/or" statements? Converting from QuattroPro example:
If(N11=""#AND#O11="","",If(N11>0,40,50))

Posted by Tim Francis-Wright on November 14, 2000 9:37 AM

Try :-
=IF(AND(N11="",O11=""),"",IF(N11>0,40,50))

The other Logical operators in QP work
the same way as functions in Excel.
Of course, in VBA, they're back to operators:
go figure!