![]() This formula will return "Good" if the value in A2 is greater than 80, a blank cell otherwise: In case you wish to return a value only when the condition is met (or not met), otherwise - nothing, then use an empty string ("") for the "undefined" argument. This formula goes to C2, and then is copied down through C7: For the detailed explanation, please see Excel IF: things to know.Īs an example, let's write a very simple IF formula that checks a value in cell A2 and returns "Good" if the value is greater than 80, "Bad" otherwise: Though this argument is optional, we recommend always configuring it to avoid unexpected results.
0 Comments
Leave a Reply. |