Excel Conditional Statements
Main.ExcelConditionals History
Hide minor edits - Show changes to output
Deleted lines 28-46:
----
(:html:)
<div id="disqus_thread"></div>
<script type="text/javascript">
/* * * CONFIGURATION VARIABLES: EDIT BEFORE PASTING INTO YOUR WEBPAGE * * */
var disqus_shortname = 'apmonitor'; // required: replace example with your forum shortname
/* * * DON'T EDIT BELOW THIS LINE * * */
(function() {
var dsq = document.createElement('script'); dsq.type = 'text/javascript'; dsq.async = true;
dsq.src = 'https://' + disqus_shortname + '.disqus.com/embed.js';
(document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(dsq);
})();
</script>
<noscript>Please enable JavaScript to view the <a href="https://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript>
<a href="https://disqus.com" class="dsq-brlink">comments powered by <span class="logo-disqus">Disqus</span></a>
(:htmlend:)
Changed lines 24-25 from:
to:
The following video tutorial demonstrates logical operations with a number guessing game.
Added line 27:
<iframe width="560" height="315" src="https://www.youtube.com/embed/fOLfIUr7DkI" frameborder="0" allowfullscreen></iframe>
Changed line 18 from:
IF - select which result to return based on logical condition
to:
IF - select a result based on logical condition
Changed line 22 from:
XOR - exclusive OR returns TRUE when both inputs are different
to:
XOR - exclusive OR is TRUE when both inputs differ
Added lines 1-46:
(:title Excel Conditional Statements:)
(:keywords analysis, Microsoft Excel, spreadsheet, greater than, less than, equal to:)
(:description Conditional statements can be implemented into a spreadsheet such as Microsoft Excel to change results based on inputs:)
The following tutorial is an introduction to Excel conditional statements using the IF command and comparison statements such as those shown below.
'''Operator'''
< - less than
<= - less than or equal to
> - greater than
>= - greater than or equal to
== - equal
<> - not equal to
Certain functions such as AND, OR, XOR, and NOT can be used to combine, select, or reverse the outcome of conditional statements. These logical operations change the results based on input data.
'''Function'''
IF - select which result to return based on logical condition
AND - return TRUE if both statements are TRUE
OR - return TRUE if either statement is TRUE
NOT - return the opposite of the input TRUE/FALSE
XOR - exclusive OR returns TRUE when both inputs are different
Cells may also be formatted differently based on the cell contents. The following video tutorial demonstrates logical operations with a number guessing game.
(:html:)
(:htmlend:)
----
(:html:)
<div id="disqus_thread"></div>
<script type="text/javascript">
/* * * CONFIGURATION VARIABLES: EDIT BEFORE PASTING INTO YOUR WEBPAGE * * */
var disqus_shortname = 'apmonitor'; // required: replace example with your forum shortname
/* * * DON'T EDIT BELOW THIS LINE * * */
(function() {
var dsq = document.createElement('script'); dsq.type = 'text/javascript'; dsq.async = true;
dsq.src = 'https://' + disqus_shortname + '.disqus.com/embed.js';
(document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(dsq);
})();
</script>
<noscript>Please enable JavaScript to view the <a href="https://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript>
<a href="https://disqus.com" class="dsq-brlink">comments powered by <span class="logo-disqus">Disqus</span></a>
(:htmlend:)
(:keywords analysis, Microsoft Excel, spreadsheet, greater than, less than, equal to:)
(:description Conditional statements can be implemented into a spreadsheet such as Microsoft Excel to change results based on inputs:)
The following tutorial is an introduction to Excel conditional statements using the IF command and comparison statements such as those shown below.
'''Operator'''
< - less than
<= - less than or equal to
> - greater than
>= - greater than or equal to
== - equal
<> - not equal to
Certain functions such as AND, OR, XOR, and NOT can be used to combine, select, or reverse the outcome of conditional statements. These logical operations change the results based on input data.
'''Function'''
IF - select which result to return based on logical condition
AND - return TRUE if both statements are TRUE
OR - return TRUE if either statement is TRUE
NOT - return the opposite of the input TRUE/FALSE
XOR - exclusive OR returns TRUE when both inputs are different
Cells may also be formatted differently based on the cell contents. The following video tutorial demonstrates logical operations with a number guessing game.
(:html:)
(:htmlend:)
----
(:html:)
<div id="disqus_thread"></div>
<script type="text/javascript">
/* * * CONFIGURATION VARIABLES: EDIT BEFORE PASTING INTO YOUR WEBPAGE * * */
var disqus_shortname = 'apmonitor'; // required: replace example with your forum shortname
/* * * DON'T EDIT BELOW THIS LINE * * */
(function() {
var dsq = document.createElement('script'); dsq.type = 'text/javascript'; dsq.async = true;
dsq.src = 'https://' + disqus_shortname + '.disqus.com/embed.js';
(document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(dsq);
})();
</script>
<noscript>Please enable JavaScript to view the <a href="https://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript>
<a href="https://disqus.com" class="dsq-brlink">comments powered by <span class="logo-disqus">Disqus</span></a>
(:htmlend:)
