KNOWLEDGEBASE - ARTICLE #653

How can I write an IF function in Prism to yield a blank (missing value) when Y is less than 0?

Y = IF (Y<0, Y/0, Y)

Prism knows that it can't divide by zero, so it makes the result blank (missing) instead.



Keywords: return null ignore

Explore the Knowledgebase

Analyze, graph and present your scientific work easily with GraphPad Prism. No coding required.