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?

0 Replies