Nested IFs follow this syntax: IF THEN ELSE IF THEN ELSE

IF true THEN action ELSE IF true THEN action ELSE ....

E.g.: =IF(A1=A2,A3,IF(A2=A4,A5,A6))

Dave


--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"GARY" wrote:

In a simple "IF" formula:

if the logical_test is TRUE, the 'value-if-true' is returned
if the logical_test is FALSE, the 'value-if-false' is returned.

(I can easily follow that).


====================

But when writing nested-IF formulas (with multiple logical_tests), I
frequently get "lost" determining which of the multiple 'value-if-
true" statements and which of the multiple 'value-if-false" statements
go with each of the multiple logical_tests.

Can someone please un-confuse me? (A visual diagram would be great!)