Real Life Problem:
Assume that, in a quiz contest there are 5 participants and played 4 games. From the score card need to calculate the Results for each player based on below conditions:
Example Data Table:
Solution:
In F2 Column you can apply few functions to get the result. But here I would like to show 2 different types of function here. One is Array formula and another is Regular formula.
Array Formula:
General Formula:
Excel is fantastic analysis tool. One problem has many solutions. You need to choose which you like best. You can do it through general formula, through an array formula, through VBA etc.
Assume that, in a quiz contest there are 5 participants and played 4 games. From the score card need to calculate the Results for each player based on below conditions:
- In F column, the result should be Win if any player scored less than or equal to 0 (Zero), in all 4 games.
- Blank means not participated. So if any player not participate in any of 4 games, then no need to calculate the result.
- All player must participate in 4 games.
Example Data Table:
Image 1: Score card
Solution:
In F2 Column you can apply few functions to get the result. But here I would like to show 2 different types of function here. One is Array formula and another is Regular formula.
Array Formula:
{=IF(OR(B2:E2="",B2:E2>0),"Loss","Win")}
Image 2: Array formula
General Formula:
=IF(MAX(B2:E2)>0,"Loss","Win")
Image 3: Result 2
Excel is fantastic analysis tool. One problem has many solutions. You need to choose which you like best. You can do it through general formula, through an array formula, through VBA etc.
|||| Please SUBSCRIBE our YouTube Channel ||||
https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw
https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw