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

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

BRIEF OF EXCEL FORMULAS (PART-1)

EBEES INFOTRAIN CONSULTANCY SERVICES PVT. LTD. 1. SUM :  Summary  The Excel SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments. Purpose  Add numbers together Return value The sum of values supplied. Syntax  =SUM (number1, [number2], [number3], ...) Examples In the example shown, the formula in D12 is: = SUM ( D6:D10 ) // returns 9.05 2.Round() :  Summary  The Excel ROUND function returns a number rounded to a given number of digits. The ROUND function can round to the right or left of the decimal point. Purpose  Round a number to a given number of digits Return value  A rounded number. Syntax  =ROUND (number, num_digits) Arguments  number  - The number to round. num_digits  ...
Post a Comment
Read more