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

TYPE OF LANGUAGE & TRANSLATORS of the Computer

                                                                            LANGUAGES OF THE COMPUTER Languages of the Computer All we known about computer that it is a electronic device. It do it task after instruction are given to it by the user. But we should also known about it's language too. Computer is a machine oriented. It understand only programming language & machine language or we can say binary language. Web Designing Courses What is Binary Language ???? Binary is a way to show any type of data (such as number and text ). Computer work only in binary language. Binary is a number system and is known as a base 2 system because it uses two characters- 0 & 1   Basic Types of Programming & Computer Languages are : 1.Low - Level Language a) M...
Post a Comment
Read more

FORMULA MS-EXCEL PART-4

                                DATE & TIME  FUNCTION   1. TODAY ( ) :- Summary  The Excel TODAY function returns the current date, updated continuously when a worksheet is changed or opened. The TODAY function takes no arguments. You can format the value returned by TODAY using any standard date format. If you need current date and time, use the  NOW function . Purpose  Get the current date Return value  Valid Excel date Syntax  =TODAY () Arguments  Usage notes  The TODAY function takes no arguments, and returns the current date, updated whenever a worksheet is changed or opened. You can also use F9 to force the worksheet to recalculate and update the value. If you need a static date that won't change, you can  enter the current date using the keyboard shortcut  Ctrl +...
Post a Comment
Read more

INPUT DEVICES

                                                What is Input Devices? Input Devices are used to enter data or information into the computer or other data processing devices. Here are some Devices as follow: Keyboard   Mouse Joystick  Scanner  Voice Input and Recognition  System Optical Mark Reader  Magnetic Ink Character Recognition  Web Camera  Video Camera  AnyProject Management Courses Short Note over Input Devices :  Keyboard Keyboard is the main input device .Programs and any type of data entered into the computer through it . keyboard is attached to the computer, may be it is wired or wireless .A keyboard is similar to the keyboard of the typewriter. It contains alphabets, numbers, special characters ,arrow keys. When keys are pressed it give electric sign...
Post a Comment
Read more