Formula Help: Isblank equivalent needed


#1

Since the Formula column displays zeros for empty cells, I need isBlank or isNotBlank formula to make my formula work.

My {Results} column needs to return a value of “Draw” if {Home goals} = {Away goals} and the {Points} column will display a value of “1” if {Result} = “Draw”. However, since a 0-0 tie is a possibility I can’t exclude zero values. Now My table displays Draw and 1 point for all upcoming matches.
Can anyone help please!
Thanks,
Anna


#2

It’s not clear from your question exactly what you’re doing. But you can make a blank field into a zero using IF:
if({home goals}="", 0, {home goals})


#3

Actually i wanted the opposite, blanks not to show zeros, so the “” worked. Thx @Katherine_Harkness