Formula

Copper Contributor

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?

1 Reply

= 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