
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 10, 2016 12:14 PM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 12, 2016 10:40 AM
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})

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 12, 2016 11:02 AM
Actually i wanted the opposite, blanks not to show zeros, so the “” worked. Thx @Katherine_Harkness
