[Free ebook]Advanced Excel by George W - EBOOKS AND TIPS FREE

EBOOKS AND TIPS FREE

Ebooks and Tips free for you.

Trang

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