Advanced Excel by George W

Author:George W. [W., George]
Language: eng
Format: epub
Published: 2017-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

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.