Help

Re: Formula Help: Isblank equivalent needed

704 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Al_Ansar_FC
5 - Automation Enthusiast
5 - Automation Enthusiast

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 Replies 2
Katherine_Harkn
6 - Interface Innovator
6 - Interface Innovator

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})

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