Skip to main content

Formula Help: Isblank equivalent needed

A
Forum|alt.badge.img+4

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

    K
    Forum|alt.badge.img+4

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

    A
    Forum|alt.badge.img+4
    Katherine_Harkn wrote:

    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

    K
    1 person likes this
    • K
      Katherine_Harkn

    Reply


    Most helpful members this week

    Terms & Conditions