New 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?

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

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


both formulas are the same but in different languages only



We support Ukraine and condemn war. Push Russian government to act against war. Be brave, vocal and show your support to Ukraine. Follow the latest news HERE