writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 25:
Line 25: + + Line 30:
Line 32: − + − + − + − + − + − + − + − − |- class="odd" − | class="sshl_f" | − | class="sshl_f" | − | class="sshl_f" | − − + − + − + − + −
no edit summary
== Examples ==
== Examples ==
<div id="6SpaceContent" class="zcontent" align="left">
<div id="6SpaceContent" class="zcontent" align="left">
<div id="6SpaceContent" class="zcontent" align="left">
{| id="TABLE3" class="SpreadSheet blue"
{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
|- class="even"
| class="sshl_f" |30
| class="sshl_f" | 30
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="odd"
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |50
| class="sshl_f" | 50
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
|- class="even"
| class="sshl_f" |
| class="sshl_f" | 13
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
|- class="odd"
| class="sshl_f" |
| class="sshl_f" | 20
| class="sshl_f" |
| class="sshl_f" | TEXT
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
|- class="even"
| class="sshl_f" |
| class="sshl_f" | FALSE
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|}
|}
=OR(A1=30) :Evaluates the condition for cell A1. Returns ''TRUE'' as an output.
=OR(A1=30) :Evaluates the condition for cell A1. Returns ''TRUE'' as an output.
=OR(A1-30=0,A1>40) :Returns ''TRUE'' as first condition is TRUE.
=OR(A1-30=0,A1>40) :Returns ''TRUE'' as first condition is TRUE.
=OR(2*B2=50) :Returns ''FALSE'' as an output.
=OR(2*B2=50) :Returns ''FALSE'' as an output.
=OR(a+b=c,d+e=f) :Returns ''NaN'' error as both arguments do not evaluate as logical values.
=OR(a+b=c,d+e=f) :Returns ''NaN'' error as both arguments do not evaluate as logical values.
==See Also==
==See Also==