• 461K Members
• 4,853 Online
• 559K Conversations

Deleted
Not applicable

# Multiple formula

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))

# Re: Multiple formula

@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