Today's post is brought to you by Frederique Klitgaard. Frédérique is a writer on Office.com (Note: this is a previously published post we publish again because it answers many.)
On my previous post about the if function, I showed follow-up in which you a very simple application of this formula, I would like to address some questions about how to use this function regularly coming.
The classification is pointed out to me, example isn't the best for the if function, but I think that it still helps illustrate the answers to the following questions.
Yes, you can do this using conditional formatting. I have a conditional formatting rule to distinguish the different results of the formula in the worksheet, a different color for cells that contain specific text.
For more information about using conditional formatting see Add, modify, search, or clear conditional formats.
Yes, meet to multiple conditions, you can use the and include and/or or functions, so that you can specify additional criteria, the up in value, whether true or false. If test results are I for testing the entire quarter, I can, for example, the AND function, to determine which completed the quarter with flying colors on the basis of the following formula:
IF(and(B2+E2>=178), "Excellent!", "")
Yes, you can text in all arguments to this function, as long as you enclose it in quotation marks. In the examples above, the formulas have returned text-based results, but you can also text in the argument test as . Want to use a star system, in addition to class, can I use, for example, the following formula:
IF (D2 = "A", "**", IF (D2 = "B", "**", IF (D2 = "C", "**", "")))
Keep in mind that two of the cells were empty. By adding two quotation marks without text in between (the last argument of this formula), I specify that cells should be empty, if the values are not the criteria. And Yes, I centered the stars after entering the formula just for looks!
Yes, you can include calculations in the formula, do the percentages. Use a point system, I could use such as the following formula:
= IF (B2 > 79, B2 B. 1%, IF (B2 > 89%, B2 ** 5%, ""))
Because commas argument in a formula are used as delimiters, be they carefully not to use as the decimal separator in the values that you want to calculate.
For more information on this feature, see our function reference article, If function.
No comments:
Post a Comment