Microsoft Office Excel 2007 Multiple IF Function

MS-Excel

Yesterday, I was posted about the IF function of the Microsoft Office Excel using the 2007, 2003, or even 97 versions that you can use to perform a logical calculations of your worksheet data. Now another use of the Microsoft Excel using the IF function is the multiple IF functions. This is understood that you can perform a series of multiple conditions base of your logical reference of your worksheet data. Using the logical test of greater than or equal to or like this (>=). This logical function can perform a multiple list of conditions using the autofill tab. By dragging your mouse downward after your syntax is logically correct base of your product entry of your worksheet.

Syntax

IF(logical_test,value_if_true,value_if_false)

Logical_test   is any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE.

Value_if_true   is the value that is returned if logical_test is TRUE. For example, if this argument is the text string "Within budget" and the logical_test argument evaluates to TRUE, then the IF function displays the text "Within budget". If logical_test is TRUE and value_if_true is blank, this argument returns 0 (zero). To display the word TRUE, use the logical value TRUE for this argument. Value_if_true can be another formula.

Value_if_false   is the value that is returned if logical_test is FALSE. For example, if this argument is the text string "Over budget" and the logical_test argument evaluates to FALSE, then the IF function displays the text "Over budget". If logical_test is FALSE and value_if_false is omitted, (that is, after value_if_true, there is no comma), then the logical value FALSE is returned. If logical_test is FALSE and value_if_false is blank (that is, after value_if_true, there is a comma followed by the closing parenthesis), then the value 0 (zero) is returned. Value_if_false can be another formula.

The Worksheet logical Syntax

By combining the above statement using the syntax it will results a multiple conditions base of your logical data(reference) by repeating itself the reference data in the first reference in a rows and columns. But before it, calculate first the logical test reference to evaluate exactly the highest reference and the low reference base of the logical of is greater than or equal to. Just do this example below: or see the above example shown in the picture above.

=IF(D4>=600,"high sales P90",IF(D4>=488,"high sales P85",IF(D4>=380,"high sales P80",IF(D4>=340,"high sales P75",IF(D4>=245,"high sales P70",IF(D4>=211,"low sales P90",IF(D4>=168,"low sales P85",IF(D4>=50,"low sales product","Very low sales"))))))))

Be sure to put exactly its of the logical functions separated with comma and the open parenthesis and close parenthesis at the end of your syntax.
Microsoft Office Excel 2007 Multiple IF Function Arnel Cartoneros 5 of 5
Yesterday, I was posted about the IF function of the Microsoft Office Excel using the 2007, 2003, or even 97 versions that you can use...
Share on Google Plus

About Arnel Cartoneros

Arnel is a Blog creator and writer, A founder and publisher of www.combinebasic.com and www.nuggetro.info. Part time Computer Instructor, Computer And Electronic Technician, And performing job as Biomedical Machine Specialist. I'm an avid fan of social media and very interested in Technical information and innovation.