Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-983842%22%20slang%3D%22en-US%22%3EFormula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-983842%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20need%20a%20formula!%20I%20have%20produced%20a%20player%20table%2C%20if%20it%20ends%20equally%20in%20the%20match%20you%20get%201%20point.%20I%20wrote%20this%20formula%20%3D%20OM%20(B1%20%3D%20D1%3B%201%3B%200)%2C%20but%20the%20problem%20is%20if%20the%20boxes%20B1%20and%20D1%20are%20empty%2C%20Excel%20will%20print%201%20point%20anyway%20and%20I%20don't%20want%26nbsp%3BExcel%20to%20do%20that.%20When%20the%20box%20is%20empty%2C%20Excel%20should%20not%20print%20any%20points%20at%20all.%20Does%20anyone%20know%20how%20to%20write%20such%20a%20formula%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-983842%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EActivity%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EChat%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECommunity%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EConversations%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20%26amp%3B%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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?

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 

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