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

Wednesday, March 25, 2020

[Free ebook]Advanced Excel by George W

[Free ebook]Advanced Excel by George W


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
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 .
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 .
#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