If you spend time on your Excel Project and you feel it can be done some other way, you may contact our Excel Help Team to help you with your Excel Project or use our Excel Question page.
More practical features can be found in our Excel Utility.
Excel's Logical Functions can be used to introduce decision making into your spreadsheet.
Download our FREE Excel Utility
Provide many features and shortcuts to your Excel use
True function returns a logical value of TRUE. Th...
And
In Excel, the And function returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE. The syntax for the And function is: And( condition1, condition2, ... ) condition is something that you want to test that can either be TRUE or FALSE. There can be up to 30 conditions
In Excel, the If function returns one value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE. The syntax for the If function is: If( condition, value_if_true, value_if_false ) condition is the value that you want to test. value_if_true is the value that is returned if condition evaluates to TRUE. value_if_false is the value that is return if condition evaluates to FALSE.
It is possible to nest multiple IF functions within one Excel formula. You can nest up to 7 IF functions to create a complex IF THEN ELSE statement. The syntax for the nesting the IF function is: IF( condition1, value_if_true1, IF(condition2, value_if_true2, value_if_false2 ) This would be equivalent to the following IF THEN ELSE statement: IF condition1 THEN value_if_true1 ELSEIF condition2 THEN value_if_true2 ELSE value_if_false2 END IF This syntax example demonstrates how to nest two IF functions. You can nest up to 7 IF functions. condition is the value that you want to test. value_if_true is the value that is returned if condition evaluates to TRUE. value_if_false is the value that is return if condition evaluates to FALSE
Question: I have a formula in Excel that I am using to test for 7 conditions, and each condition if true will return a different value. However, I now need to test a total of 12 possible values. The limitation of the nested IFs is that you can only nest up to 7. Is there an alternative to this formula to test so that I can test for 12 values instead of 7? =IF(A1="10X12",140,IF(A1="8x8",64,IF(A1="6x6",36,IF(A1="8x10",80,IF(A1="14x16",224,IF(A1="9x9",81,IF(A1="4x3",12))))))) Answer: There is no built-in alternative formula in Excel, but you could write your own function in VBA and then call this new function instead. Let's take a look at an example.
In Excel, the Not function returns the reversed logical value. The syntax for the Not function is: Not( logical_value ) logical_value is an expression that either evaluates to TRUE or FALSE. If the Not function is used with an expression of TRUE, then FALSE is returned. If the Not function is used with an expression of FALSE, then TRUE is returned.
In Excel, the Or function returns TRUE if any of the conditions are TRUE. Otherwise, it returns FALSE. The syntax for the Or function is: Or( condition1, condition2, ... ) condition is something that you want to test that can either be TRUE or FALSE. There can be up to 30 conditions.
