Skip to main content

BRIEF OF FORMULA MS-EXCEL PART-2


                       PART -2 



             ðŸ‘‰ LOGICAL FUNCTION








1. IF FUNCTION






Summary 
The IF function can perform a logical test and return one value for a TRUE result, and another for a FALSE result. For example, to "pass" scores above 70: =IF(A1>70,"Pass","Fail"). More than one condition can be tested by nesting IF functions. The IF function can be combined with logical functions like AND and OR.
Purpose 
Test for a specific condition
Return value 
The values you supply for TRUE or FALSE
Syntax    
=IF (logical_test, [value_if_true], [value_if_false])
Arguments 
  • logical_test - A value or logical expression that can be evaluated as TRUE or FALSE.
  • value_if_true - [optional] The value to return when logical_test evaluates to TRUE.
  • value_if_false - [optional] The value to return when logical_test evaluates to FALSE.

2. TRUE FUNCTION



Summary 
The Excel TRUE function returns the value TRUE. TRUE is classified as a compatibility function, and not needed in most cases. It is equivalent to using the Boolean value TRUE directly in a formula.
Purpose 
Generate the logical value TRUE
Return value 
The logical value TRUE
Syntax 
=TRUE ()
Arguments 
Usage notes 
The TRUE function is provided for compatibility with other spreadsheet applications and there is no need to use it in standard situations.
If you want to enter TRUE, or provide TRUE as a result in a formula, you can just use enter the word TRUE directly into a cell or formula and Excel will interpret this as the logical value TRUE. For example, these formulas are functionally identical:


=IF(A1<0, TRUE())
=IF(A1<0, TRUE)
Also note that logical expressions themselves will automatically generate TRUE and FALSE results. For example, the formula in cell C7 is:
=B7>90

2. FALSE FUNCTION
















































Summary 







The Excel FALSE function returns the value FALSE. FALSE is classified as a compatibility function, and not needed in most cases. It is equivalent to using the Boolean value FALSE directly in a formula.











Purpose 





Generate the logical value FALSE









Return value 





The logical value FALSE









Syntax 







=FALSE ()











Arguments 































Usage notes 







The FALSE function takes no arguments and generates the boolean value FALSE. 



For example, to return FALSE if if the value in A1 < 0, use the formula:




=IF(A1<0, FALSE())







Note that you can also just use enter the word FALSE directly into a cell or formula and Excel will interpret this as the logical value FALSE. For example, these formulas are functionally identical:




=IF(A1<0, FALSE())
=IF(A1<0, FALSE)







Both formulas return FALSE if the value in A1 < 0.



Microsoft labels the FALSE function a "compatibility function", in Excel for compatibility with other spreadsheet applications.

Comments

Post a Comment

Popular posts from this blog

WHAT IS A COMPUTER? Hardware & Software

In this blog we will discuss about ,"What is computer and differences among its part as Hardware & Software". We know that all information are scattered in google but I want to make it easy for our readers.Otherwise it is difficult to know which information is right and which is wrong . My Blog is dedicated to learners & easy learning  WHAT IS A COMPUTER? What is Computer  : Computer is an electronic device that is designed to work with Information. The term computer is derived from the Latin term  ‘compute’ , this means to  calculate  or  programmable machine .   Therefore computers can perform complex and repetitive procedures quickly, precisely and reliably. Modern computers are electronic and digital. All general-purpose computers require the following hardware components: §   Central processing unit (CPU) : The heart of the computer, this is the component that actually executes instruction...
2 comments
Read more

SOME UNKNOWN ABOUT COMPUTER PART-2

                            PART -2  ( UNKNOWN FACTS) A) Charles Babbage in 1833 invented all the parts that are now used for the modern computer. But the first ‘modern’ computer was invented only 120 years later.   EBEES CORP B)Z1 was the first fully operational digital computer developed by Konrad Zuse in 1936.  In 1939 , he created the Z2 as the first  electro-mechanical computer in the world. While Charles Babbage is being considered as the “ father of the computer ”, Zuse can be considered as the inventor of the “modern computer”. C) The first disk drive to use removable media was the IBM 1311 . You may not believe, but as you can see in the image below, it resembles the look of a washing machine. It was quite big, yet it had a storage capacity of fewer than 5 megabytes.    DISK DRIVE D) Amazon.com did not start ...
Post a Comment
Read more

DIFFERENT OPERATORS IN MS-EXCEL

                                    OPERATORS   Operators are used in formulas to execute operations on the values taken by formulas.  Excel use 4 types of operators : 1.Arithmetic Operators 2.Text Concatenation Operators  3.Comparison Operators  4.Reference Operators  www.ebeescorp.com Arithmetic Operators This operation will explained through example Example  Text Concatenation Operators   This operation will explained through example Example  Comparison Operators  To compare values you can create formulas using comparison operators. These operators return a TRUE or FALSE result depending how the formula evaluate the condition .Some common operator are as follow: Reference Operators  Reference operators enable you to combine absolute and relative references and na...
Post a Comment
Read more