Forum Discussion

henkeson's avatar
henkeson
Copper Contributor
Nov 05, 2019

Formula

I need a formula! I have produced a player table, if it ends equally in the match you get 1 point. I wrote this formula = OM (B1 = D1; 1; 0), but the problem is if the boxes B1 and D1 are empty, Excel will print 1 point anyway and I don't want Excel to do that. When the box is empty, Excel should not print any points at all. Does anyone know how to write such a formula?

Activity
Chat
community
Conversations
tips & tricks

1 Reply

Sort By
  • henkeson's avatar
    henkeson
    Copper Contributor
    Nov 24, 2019

    = OM (B1 = D1; 1; 0) Swedish formula

    = IF (B1 = D1; 1; 0) English formula

     

    both formulas are the same but in different languages only

     

    henkeson 

Resources