IF(...)
Formula to plot only non zero values on charts.
Used Functions
Category: Logical
Specifies a logical test to perform
Syntax
IF(Something is True, then do something, otherwise do something else)
Practice IF Formula at Sheetzoom
IF formula at Microsoft helpCategory: Logical
Returns TRUE if any argument is TRUE
Syntax
OR(logical1, [logical2], ...)
Category: Information
Returns TRUE if the value is blank
Syntax
ISBLANK(value)
Category: Information
Returns the error value #N/A
Syntax
NA( )
0
The formula return for zero values NA() function that is not plotted by the chart itself. Thus helping us to make better charts.