[Free ebook]Excel Reporting Strategies: A Quick & Easy Guide to Report Integration & Manipulation by Chelsea Bloomfield Eckley

DOWNLOAD PDF
DOWNLOAD EPUB

Author:Chelsea Bloomfield Eckley [Bloomfield Eckley, Chelsea]
Language: eng
Format: epub
Publisher: UNKNOWN
Published: 2019-09-29T07:00:00+00:00

Tips:

Quotation marks must be used for non-numerical values

Pay attention to the color of the parenthesis in Excel. The color helps identify, which IF STATEMENT the parenthesis is encompassing.

Diagram 5.3: Nested IF Statements by Color

=IF(E2="Apples","RED","FALSE")

=IF(E3="Apples", "RED", IF(E3="Honey", "YELLOW","FALSE"))

=IF(E4="Apples", "RED", IF(E4="Honey", "YELLOW", IF(E4="Zucchini", "GREEN", "FALSE")))

=IF(E5="Apples", "RED", IF(E5="Honey", "YELLOW", IF(E5="Zucchini", "GREEN", IF(E5="Eggs", "WHITE", "FALSE"))))

#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1