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

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

COMPUTER ABBREVIATIONS & SOME INVENTORS

ABBREVIATIONS EBEESCORP www.ebeescorp.com Inventors Of Computer Hardware  (1) Key board — Herman Hollerith, first keypunch device in 1930 (2) Transistor — John Bardeen, Walter Brattain & Wiliam Shockley (1947 - 1948) (3) RAM —        An Wang and Jay Forrester (1951) (4) Trackball — Tom Cranston and Fred Longstaff (1952) (5) Hard Disk — IBM , The IBM Model 350 Disk File (1956 ) (6) Integrated Circuit — Jack Kilby & Robert Noyce (1958) (7) Computer Mouse — Douglas Engelbart (1964) (8) Laser printer — Gary Stark weather at XEROX in (1969) (9) Floppy Disk — Alan Shugart & IBM( 1970) (10) Microprocessor — Faggin, Hoff&Mazor – Intel 4004 COMPUTER TRAINING CENTER 9717717164
Post a Comment
Read more

CHARACTERISTICS OF A COMPUTER & CENTRAL PROCESSING UNIT (C.P.U)

Hello, Readers This Blog will help you understand the Characteristics of Computer & About C.P.U (Central Processing Unit ). Characteristic means Computer capabilities i.e Characteristics of Computer  1.Speed 2.Accuracy 3.Consistency 4. Data Storing Capability 5.Flexibility  A. Speed : A Computer is a very fast device .It can perform , in a few Second ,the amount of work that a human being can do in an entire year working round the clock .The speed of the computer is usually 2 to 4 GHz . A powerful computer is capable of performing  about 10 to 40 million arithmetic calculations in a second. or We can say that Computer speed is measured in   megahertz (MHz) or gigahertz (GHz). One Megahertz equals to one million ticks per second,one Gigahertz equals one billion ticks per second . B. Accuracy : The accuracy of a Computer is consistently high an the degree o accuracy of a particular task is 100% accurate.In  a every computer each and e...
Post a Comment
Read more