This post will guide you how to show only positive values in an excel formula. How to show formula result only if it is a positive value in excel. Is there a way to have a formula return only positive numbers in excel.
Show Only Positive Values
Assuming that you have a list of data, and you want to sum the range of cells A1:C5 and if the summation result is greater than 0 or is a positive number, then display this result. Otherwise, display as a blank cell.
Type this formula into the formula box of the cell D1, then drag AutoFill Handler over other cells to apply this formula.
You will see that the returned results of this formula only show positive values.
- Excel SUM function
The Excel SUM function will adds all numbers in a range of cells and returns the sum of these values. You can add individual values, cell references or ranges in excel.The syntax of the SUM function is as below:= SUM(number1,[number2],…)…
- Excel IF function
The Excel IF function perform a logical test to return one value if the condition is TRUE and return another value if the condition is FALSE. The IF function is a build-in function in Microsoft Excel and it is categorized as a Logical Function.The syntax of the IF function is as below:= IF (condition, [true_value], [false_value])….