Blue Flower

Most popular PC and Cell Phone Games

How to calculate the most expensive and the cheapest game for PC and Mobile - popular PC games for kids

Using Excel very quickly, we can calculate the specific requirements for game prices.

In this Excel example, the tutorial will show how Excel can perform the calculation according to the specific application.

In the example below evident in column 'A' group games for computers and mobile phones. In column 'B' note the names of popular games PC and Mobiles for kids (please see list below)

1. Most popular PC games

  • The Long Dark
  • Darkwood
  • Routine
  • Planetary Annihilation
  • Civilization: Beyond Earth
  • Dragon Age: Inquisition
  • Diablo 3: Reaper of Souls
  • Broken Age
  • Wolfenstein The New Order
  • Assassin's Creed: Unity
  • Everquest Next
  • Watch Dogs
  • Wasteland 2
  • South Park: The Stick of Truth
  • Hotline Miami 2: Wrong Number
  • Tropico 5
  • Lords of the Fallen
  • The Sims 4
  • Titanfall
  • The Elder Scrolls Online

2. Popular Actions games

  • Gears of War - Xbox 360
  • Resident Evil 4 - Wii
  • God of War and God of War 2
  • Tools of Destruction
  • Ghost Recon Advanced Warfighter 2
  • Crackdown
  • Drake's Fortune
  • SCUM Game

3. Popular PC Games For Kids

  • World of ZOO
  • Nancy Drew
  • Itzabitza
  • Babysitting mania
  • Cake mania 3
  • Star Wars
  • Lucidity
  • My Sims

In 'C' Column note prices for each game without taxes.

ATTENTION! These prices are not real for games, they are unrealistic and set of example tutorial only.

In 'D' column you see game prices with tax.

A

B

D

1

 Most popular PC game

Price

Price with tax

2

 

The Long Dark

$100,00

$125,00

3

 

Darkwood

$100,00

$125,00

4

 

Routine

$100,00

$125,00

5

 

Planetary Annihilation

$100,00

$125,00

6

 

Civilization: Beyond Earth

$170,00

$212,50

7

 

Dragon Age: Inquisition

$100,00

$125,00

8

 

Diablo 3: Reaper of Souls

$100,00

$125,00

9

 

Broken Age

$200,00

$250,00

10

 

Wolfenstein The New Order

$220,00

$275,00

11

 

Assassin's Creed: Unity

$100,00

$125,00

12

 

Everquest Next

$300,00

$375,00

13

 

Watch Dogs

$100,00

$125,00

14

 

Wasteland 2

$100,00

$125,00

15

 

South Park: The Stick of Truth

$380,00

$475,00

16

 

Hotline Miami 2: Wrong Number

$120,00

$150,00

17

 

Tropico 5

$100,00

$125,00

18

 

Lords of the Fallen

$150,00

$187,50

19

 

The Sims 4

$100,00

$125,00

20

 

Titanfall

$200,00

$250,00

21

 

The Elder Scrolls Online

$100,00

$125,00

22

   

$147,00

 

23

 Popular Actions games

Price

Price with tax

24

 

Gears of War - Xbox 360

$100,00

$125,00

25

 

Resident Evil 4 - Wii

$100,00

$125,00

26

 

God of War and God of War 2

$100,00

$125,00

27

 

Tools of Destruction

$100,00

$125,00

28

 

Ghost Recon Advanced Warfighter 2

$170,00

$212,50

29

 

Crackdown

$100,00

$125,00

30

 

Drake's Fortune

$214,00

$267,50

31

   

$126,29

 

32

 Popular PC Games For Kids

Price

Price with tax

33

 

World of ZOO

$7,00

$8,75

34

 

Nancy Drew

$420,00

$525,00

35

 

Itzabitza

$10,00

$12,50

36

 

Babysitting mania

$15,00

$18,75

37

 

Cake mania 3

$10,00

$12,50

38

 

Star Wars

$17,00

$21,25

39

 

Lucidity

$21,00

$26,25

40

 

My Sims

$10,00

$12,50

41

   

$63,75

 

42

       

43

 

Name

The 
cheapest
 game 

The most
 expensive game 

44

 

Games

World of ZOO

Nancy Drew

45

   

$7,00

$420,00

 

In the table you notice that the game is the most expensive and which game is the cheapest.

To calculate the price with tax for a single game using the following formula.

=(C2*25/100)+C2

The average cost of all games by groups in cells C10, C19 and C29 using the AVERAGE Excel function to calculate using the following formula.

=AVERAGE(C2:C9)

What is the cheapest game

To calculate which is the cheapest game use this formula using Excel MIN function nested in INDEX/MATCH formula.

In 'C44' cell set the following formula

=INDEX(B2:B40;MATCH(MIN(C2:C40);C2:C40;0))

and in 'C45' cell the following formula

=MIN(C2:C9;C12:C18;C21:C28)

What is the most expensive game

To calculate the most expensive game use this formula using Excel MAX function.function nested in INDEX/MATCH formula.
In 'D44' cell set the following formula

=INDEX(B2:B40;MATCH(MAX(C2:C40);C2:C40;0))

and in cell D45 the following formula

=MAX(C2:C9;C12:C18;C21:C28)

ATTENTION! These prices are not real games proces, they are unrealistic and set of example only tutorial.