Changes

Jump to navigation Jump to search
1 byte removed ,  23:26, 14 December 2013
no edit summary
Line 25: Line 25:     
== Examples ==
 
== Examples ==
 +
 +
<div id="6SpaceContent" class="zcontent" align="left">
    
<div id="6SpaceContent" class="zcontent" align="left">
 
<div id="6SpaceContent" class="zcontent" align="left">
Line 30: Line 32:  
{| 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" |
  −
|- 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==
 
==See Also==
writer
2,661

edits

Navigation menu