LibreOffice 25.2 Help
āϞāĻāĻŋāĻā§āϝāĻžāϞāĻŋ āĻĻā§āĻāĻāĻŋ āĻāĻā§āϏāĻĒā§āϰā§āĻļāύ āĻāĻāϤā§āϰāĻŋāϤ āĻāϰāĻž āĻšā§āĨ¤
Result = Expression1 And Expression2
āĻĢāϞāĻžāĻĢāϞ: āϝā§āĻā§āύ⧠āϏāĻāĻā§āϝāĻžāϏā§āĻāĻ āĻā§āϰāĻŋā§ā§āĻŦāϞ āϝāĻž āϏāĻŽāĻžāĻŦā§āĻļā§āϰ āĻĢāϞāĻžāĻĢāϞ āϰā§āĻāϰā§āĻĄ āĻāϰ⧠āĻĨāĻžāĻā§āĨ¤
āĻāĻā§āϏāĻĒā§āϰā§āĻļāύ⧧, āĻāĻā§āϏāĻĒā§āϰā§āĻļāύ⧍: āϝā§āĻā§āύ⧠āĻāĻā§āϏāĻĒā§āϰā§āĻļāύ āϝāĻž āĻāĻĒāύāĻŋ āϏāύā§āύāĻŋāĻŦā§āĻļ āĻāϰāϤ⧠āĻāĻžāύāĨ¤
AND āĻāϰ āϏāĻžāĻĨā§ āĻāĻāϤā§āϰāĻŋāϤ āĻŦā§āϞāĻŋā§āĻžāύ āĻāĻā§āϏāĻĒā§āϰā§āĻļāύ True āĻĒā§āϰāĻĻāĻžāύ āĻāϰ⧠āĻĨāĻžāĻā§ āϝāĻĻāĻŋ āĻāĻā§ āĻāĻā§āϏāĻĒā§āϰā§āĻļāύ True āĻŽā§āϞā§āϝāĻžā§āύ āĻāϰ⧠āĻĨāĻžāĻā§āĨ¤
True AND True, True āĻĒā§āϰāĻĻāĻžāύ āĻāϰā§; āĻ āύā§āϝ āϏāĻāĻāϞ āϏāύā§āύāĻŋāĻŦā§āĻļā§āϰ āĻāύā§āϝ āĻĢāϞāĻžāĻĢāϞ āĻšāϞ⧠FalseāĨ¤
AND āĻ āĻĒāĻžāϰā§āĻāϰā§āϰ āϏāĻžāĻšāĻžāϝā§āϝ⧠āĻĻā§āĻāĻāĻŋ āϏāĻāĻā§āϝāĻžāϏā§āĻāĻ āĻāĻā§āϏāĻĒā§āϰā§āĻļāύ⧠āĻŦāĻŋāĻĻā§āϝāĻŽāĻžāύ āĻāĻāĻāϰā§āĻĒ āĻ āĻŦāϏā§āĻĨāĻžāύāϝā§āĻā§āϤ āĻŦāĻŋāĻā§āϰ āĻŦāĻŋāĻāĻ āύā§āϏāĻžāϰ⧠āϤā§āϞāύāĻž āĻāϰāĻž āϝāĻžā§āĨ¤
Sub ExampleAnd
Dim A As Variant, B As Variant, C As Variant, D As Variant
Dim vVarOut As Variant
A = 10: B = 8: C = 6: D = Null
vVarOut = A > B And B > C REM āĻŽāĻžāύ -1 āĻĒā§āϰāĻĻāĻžāύ āĻāϰā§
vVarOut = B > A And B > C REM āĻŽāĻžāύ 0 āĻĒā§āϰāĻĻāĻžāύ āĻāϰā§
vVarOut = A > B And B > D REM āĻŽāĻžāύ 0 āĻĒā§āϰāĻĻāĻžāύ āĻāϰā§
vVarOut = (B > D And B > A) REM āĻŽāĻžāύ 0 āĻĒā§āϰāĻĻāĻžāύ āĻāϰā§
vVarOut = B And A REM, 8 āĻĒā§āϰāĻĻāĻžāύ āĻāϰ⧠āĻĨāĻžāĻā§, āĻāĻā§ āĻāϰāĻā§āĻŽā§āύā§āĻā§āϰ āĻŦāĻŋāĻ āĻ
āύā§āϏāĻžāϰ⧠AND āϏāĻāϝā§āĻāύā§āϰ āĻŽāĻžāϧā§āϝāĻŽā§
End Sub