Anyone who has used Excel for a while will have found on more than one occasion long formulas that use the IF function inside another IF that in turn is inside another IF. This is normally called NESTED IF.
An easy example of NESTED IF would be:
= IF (B1 = 1, "Apple", IF (B1 = 2, "Orange", IF (B1 = 3 "Pera", "Grape")))
Obviously instead of the name of the fruits we could write a formula, or a cell.
= IF (B1 = 1, A1, IF (B1 = 2, A1-C1, IF (B1 = 3, A1 * D1, A1 ^ 2)))
Showing posts with label NESTED Ifs. Show all posts
Showing posts with label NESTED Ifs. Show all posts
Tuesday, 10 February 2015
Subscribe to:
Posts (Atom)