Changes

Manuals/calci/OR (view source)

Revision as of 23:26, 14 December 2013

1 byte removed , 23:26, 14 December 2013

no edit summary

Line 25: Line 25:

== Examples ==

+

Line 30: Line 32:

{| id="TABLE3" class="SpreadSheet blue"

|- class="even"

−

| class="sshl_f" |30

+

| class="sshl_f" | 30

−

| class="sshl_f" |

+

| class="sshl_f" |

|- class="odd"

| class="sshl_f" |

−

| class="sshl_f" |50

+

| class="sshl_f" | 50

| class="sshl_f" |

|- class="even"

−

| class="sshl_f" |

+

| class="sshl_f" | 13

| class="sshl_f" |

|- class="odd"

−

| class="sshl_f" |

+

| class="sshl_f" | 20

−

| class="sshl_f" |

+

| class="sshl_f" | TEXT

| class="sshl_f" |

|- class="even"

−

| class="sshl_f" |

+

| class="sshl_f" | FALSE

| class="sshl_f" |

−

~~|- class="odd"~~

−

~~| 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==

Swapna

writer

2,661

edits