Home

Multiple formula

%3CLINGO-SUB%20id%3D%22lingo-sub-820170%22%20slang%3D%22en-US%22%3EMultiple%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-820170%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20afternoon%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EHope%20someone%20can%20guide%20or%20assist%20me%20in%20my%20issue.%20I%20run%20a%20darts%20team%20and%20wish%20to%20generate%20a%20self%20populating%20score%20sheet.%20My%20problem%20is%20each%20game%20is%20the%20best%20of%203%20legs%20and%20I%20wish%20to%20be%20able%20to%20populate%20a%20single%20cell%20(averages)%20to%20cover%20both%20outcomes%20a%202-0%20win%2Fdefeat%20or%20a%202-1%20win%2Fdefeat.%20I%20have%20worked%20out%20the%20formulae%20for%20each%20of%20those%20averages%20outcomes%20but%20I%20wish%20to%20enable%20the%20cell%20to%20return%20that%20average%20for%20a%202%20leg%20or%203%20leg%20outcome.%20Is%20this%20possible.%20See%20attached%20section%20of%20the%20sheet.%20The%20two%20formulae%20I%20am%20using%20is%20as%20follows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%203%20legs%3A-%20%3Dsum((1503-(Cell%20v8%2Bv9%2Bv10))%2FCell%20u8%2Bu9%2Bu10))%3C%2FP%3E%3CP%3EFor%202%20legs%3A-%20%3Dsum((1002-((cell%20v8%2Bv9))%2F(cell%20u8%20%2Bu9))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-820170%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-820831%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-820831%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F397417%22%20target%3D%22_blank%22%3E%40Razor_Green%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFrom%20your%20screenshort%20it's%20not%20clear%20what%20you'd%20like%20to%20calculate%2C%20and%2C%20in%20particular%2C%20how%20do%20you%20count%20number%20of%20legs.%20As%20for%20your%20formulas%20that%20could%20be%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIF(COUNT(%3CNUMBER%20of%3D%22%22%20legs%3D%22%22%3E)%3D3%2C1503%2B(V8%2BV9%2BV10)%2F(U8%2BU9%2BU10)%2C1002%2B(V8%2BV9)%2F(U8%2BU9))%3C%2FNUMBER%3E%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

Good afternoon,



Hope someone can guide or assist me in my issue. I run a darts team and wish to generate a self populating score sheet. My problem is each game is the best of 3 legs and I wish to be able to populate a single cell (averages) to cover both outcomes a 2-0 win/defeat or a 2-1 win/defeat. I have worked out the formulae for each of those averages outcomes but I wish to enable the cell to return that average for a 2 leg or 3 leg outcome. Is this possible. See attached section of the sheet. The two formulae I am using is as follows.

 

For 3 legs:- =sum((1503-(Cell v8+v9+v10))/Cell u8+u9+u10))

For 2 legs:- =sum((1002-((cell v8+v9))/(cell u8 +u9))

 

 

1 Reply

@Deleted 

From your screenshort it's not clear what you'd like to calculate, and, in particular, how do you count number of legs. As for your formulas that could be like

=IF(COUNT(<number of legs>)=3,1503+(V8+V9+V10)/(U8+U9+U10),1002+(V8+V9)/(U8+U9))

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies