[Free ebook]Advanced Excel by George W - KING OF EXCEL

KING OF EXCEL

KINGEXCEL.INFO ( KING OF EXCEL ) Welcome KINGEXCEL.INFO - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Wednesday, March 25, 2020

[Free ebook]Advanced Excel by George W

[Free ebook]Advanced Excel by George W


DOWNLOAD PDF
DOWNLOAD EPUB

Author:George W. [W., George]
Language: eng
Format: epub + pdf
Published: 2019-03-08T08:00:00+00:00
Figure 8-40. The AND function is completed; [value_if_true], is highlighted to let you know that you should now enter this argument for the IF function
10.
Enter "A", for the true argument. Enter "") for the false argument. This will display
a blank. The complete formula is =IF(AND(Subject="Math",Sex="M",Age<21),
"A","") .
If you didn’t enter "" for the false part Excel would by default display the word False .
11.
If you wanted to see or make a change to your formula you could click the word IF
and then click the Insert Function button (Formula tab | Function Library).
You can see that the AND condition is false; therefore our result is a blank. See Figure 8-41 .
289
#evba #etipfree #eama #kingexcel

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

No comments:

Post a Comment