Zelaron Gaming Forum

Zelaron Gaming Forum (http://zelaron.com/forum/index.php)
-   The Lounge (http://zelaron.com/forum/forumdisplay.php?f=183)
-   -   Question (http://zelaron.com/forum/showthread.php?t=53951)

-Spector- 2017-03-23 07:09 PM

Question
 
Why was six afraid of seven?

!King_Amazon! 2017-03-24 02:23 AM

http://i.imgur.com/LX9xa48.jpg

-Spector- 2017-03-24 02:31 AM

Lol.

The actual answer is because seven is a six offender.

!King_Amazon! 2017-03-24 02:37 AM

BORKED

Kazilla 2017-04-02 01:11 AM

https://docs.google.com/spreadsheets...it?usp=sharing

How do I get the win %?

Originally I was trying =CountIf(A:A="BfG") / ... then I get stuck
I can't do CountIf(E:E="Alliance") because some of those are attached to a different battleground. How do?

WetWired 2017-04-02 10:54 AM

In sheets, you can actually setup a formula to test both conditions and accumulate, but it's been too long. The simplest solution is to add a column that evaluates to one if the required conditions for the row are met, and zero otherwise, then sum. There are various ways to import different data sets so you could do this in one book


All times are GMT -6. The time now is 05:28 AM.

Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
This site is best seen with your eyes open.