Excel Tutorial Topics
MS Excel IF ELSE is logical function in which performs logical test. We check multiple conditions with IF ELSE in a single formula which is also known as NESTED IF ELSE. Seven IF could be used in a single IF function.
=IF(CONDITION, value if true, value if false)
=IF(10<20,"Correct 20 is greater than 10","20 is not greater than 10")
Result: Correct 20 is greater than 10
Nested IF ELSE is nothing but more complex structure of IF ELSE functions wherein we can add logic inside a logic. You can use seven IF in a single IF function.
=IF(CONDITION, value if true, value if false)
=IF(A1>A2,"Value in cell A1 isgreater than A2"",IF(A2>A1,"Value in cell A2 is greater than A1","Value in cell A2 and A1 are equal"))
Referring to the Excel table above we are comparing values in cell A1 and A2. Here we are checking two conditions with nested If Else function:.
Copyright © All rights reserved | Powered by Webs Jyoti