Solve Excel problem (3)

(3 votes, average: 3.67 out of 5)
Loading ... Loading ...
Posted by Pedro Borges | Excel problems | Monday 16 February 2009 11:48 pm

The School Board offers 3 coffees per day to all teachers.
If the teacher drinks per week more than 3 coffees in 2 or less days, he has to pay 2 euros for each of those days.
If the teacher drinks per week more than 3 coffees for more than 3 days, he has to pay 5 euros for each of those days.
Pay attention to the example:

  A B C D E F G
1   Monday Tuesday Wednesday Thursday Friday  
2 Charles 3 3 3 3 3 Charles pays 0 euros
3 Thelma 3 3 4 3 3 Thelma pays 2 euros
4 Hugo 4 4 2 4 2 Hugo pays 15 euros
5 Yuri 4 4 4 4 4 Yuri pays 25 euros
6 Sophie 2 2 3 4 3 ???

Help the School Board by posting the Excel Formula in G6.

Solve Excel problem (2)

(3 votes, average: 3.67 out of 5)
Loading ... Loading ...
Posted by Pedro Borges | Excel problems | Tuesday 10 February 2009 11:02 pm

A teacher is building an excel spreadsheet to grade the students.

  A B C D E F G H
1 Question Number 1 2 3 4 5
2 Question Score 7 7 2 2 2 20 RESULT
3 Hugo 60% 55% 25% 60% 90% 11,55 Hugo passed the exam
4 Frank 0% 53% 90% 75% 75% 8,51 Frank goes to oral exam
5 Ginger 0% 30% 0% 30% 80% 4,30 Ginger Failed the exam
6 Denise 20% 100% 0% 75% 0% 9,90 Denise goes to oral exam
7 Wilma 45% 100% 100% 20% 100% 14,55 ???

Help the teacher by posting the formula in the column RESULT.

Solve Excel problem (1)

(1 votes, average: 5.00 out of 5)
Loading ... Loading ...
Posted by Pedro Borges | Excel problems | Saturday 7 February 2009 9:33 pm

Post the formula that gives the result in the column AH (column RESULT).

  A B C D E … AF AG AH
1 Worker Day 1 Day 2 Day 3 Day 4 … Day 31 Minutes RESULT
2 Smith 30 0 0 0 … 10 50 50 minutes
3 Mary 60  0 0  0 …  0 65 1 hour 5 minutes
4 John 480 0 0 0 … 0 480 1day
5 Matew 10 0 10 0 … 480 545 1day 1hour 5minutes
6 Tim 30 80 100 0 … 200 700 ???