Use an Excel IF Formula to Show NO or the Value in A3
Question details
Create a formula that displays NO in cell A2 when the value in A3 is below 50, and otherwise displays the value from A3.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user needs to evaluate a numeric value in A3 and show a conditional result in A2.
- Observed behavior
- A2 should return NO for values below 50 and return the A3 value for values of 50 or greater.
Make sure A3 contains a number and that A2 is available for the formula result. If A3 may contain text or be blank, decide how those entries should be handled before applying the formula.
Enter an IF formula in A2 to evaluate the value in A3
Use this formula when A2 should show a text result for values below 50 and otherwise return the original value from A3.
The IF function tests whether A3 is less than 50. When the condition is true, it returns "NO"; when it is false, it returns the value stored in A3.
Click cell A2, where you want the conditional result to appear.
Type or paste =IF(A3<50,"NO",A3) into A2.
Press Enter. A2 displays NO when A3 is below 50; otherwise, it displays the value from A3.
Use an IF Formula in WPS Spreadsheet to Show NO or an A3 Value
WPS Spreadsheet supports the same IF formula structure for conditional results. Enter the formula in A2 to show NO when A3 is below 50, or return the A3 value when it meets the threshold.
- 1. Open the worksheet in WPS Spreadsheet: Open your workbook in WPS Office and select the worksheet containing cells A2 and A3.
- 2. Select cell A2: Click A2 to set the location for the conditional result.
- 3. Insert the formula: Enter =IF(A3<50,"NO",A3) in the formula bar or directly in cell A2.
- 4. Apply the formula: Press Enter to calculate the result based on the current value in A3.
Frequently Asked Questions
What does =IF(A3<50,"NO",A3) do?
It checks whether A3 is less than 50. If it is, the formula returns NO; if it is not, the formula returns the value in A3.
Will the formula return 50 or NO when A3 equals 50?
It returns 50 because the condition uses A3<50. A value equal to 50 is not less than 50.
How can I show NO when A3 is 50 or less?
Use =IF(A3<=50,"NO",A3). The <= operator includes values equal to 50.
Can I copy this IF formula down to other rows?
Yes. Select A2 and drag the fill handle downward. Excel or WPS Spreadsheet changes A3 to the corresponding row reference, such as A4 or A5.
