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.

13 Comments »

  1. Comment by Marcio Montezinho — February 16, 2009 @ 4:28 pm

    =SE(H8<8,5;CONCATENAR(B8;” Reprovou”);SE(H8<10;CONCATENAR(B8;” vai a Oral”);CONCATENAR(B8;” PASSOU”)))

  2. Comment by Tiago Leal — February 16, 2009 @ 4:29 pm

    =SE(H4<8,5;CONCATENAR(B4;” Failed”);SE(H4<10;CONCATENAR(B4;” Goes to Oral Exam”);CONCATENAR(B4;” Passed”)))

    :D

  3. Comment by Sandra Marcolino — February 16, 2009 @ 4:31 pm

    =SE(H7<8,5;CONCATENAR(B7;” Failed”);SE(H7<10;CONCATENAR(B7;” goes to Oral”);CONCATENAR(B7;” passed”)))

  4. Comment by Carlos Coutinho — February 16, 2009 @ 4:38 pm

    = SE (G7 <8,5; CONCATENAR (A7; “failed”); SE (G7 <10; CONCATENAR (A7; “goes to exame oral”); CONCATENAR (A7; “PASSED”)))

  5. Comment by Patricia Alves — February 16, 2009 @ 4:39 pm

    =SE(H8<8,5;CONCATENAR(B8;” Reprovou”);SE(H8<10;CONCATENAR(B8;” vai a Oral”);CONCATENAR(B8;” PASSOU”)))

  6. Comment by Carolina Alves — February 16, 2009 @ 9:17 pm

    =SE(H8<8,5;CONCATENAR(B8;” Reprovou”);SE(H8<10;CONCATENAR(B8;” vai a Oral”);CONCATENAR(B8;” PASSOU”)))

  7. Comment by Leandro Aquino — February 17, 2009 @ 9:27 am

    It formulates it is: =SE(H8<8,5;CONCATENAR(B8;” failed”);SE(H8<10;CONCATENAR(B8;” Oral”);CONCATENAR(B8;” passed”)))

  8. Comment by Ricardo Pimentel — February 17, 2009 @ 10:20 am

    =SE(G7<8,5;CONCATENAR(A7;” failed”);SE(G7<10;CONCATENAR(A7;” goes to oral exam”);CONCATENAR(A7;” passed”)))

  9. Comment by Davide Varandas — February 17, 2009 @ 10:26 am

    =SE(G7<8,5;CONCATENAR(A7;” Failed”);SE(G7<10;CONCATENAR(A7;” goes to oral “);CONCATENAR(A7;” passed”)))

  10. Comment by Hugo Correia — February 17, 2009 @ 10:27 am

    =SE(A7<8,5;CONCATENAR(A7;” Failed”);SE(G7<10;CONCATENAR(A7;” go to Oral”);CONCATENAR(A7;” Passed”)))

  11. Comment by João Paulo — February 25, 2009 @ 9:09 am

    It formulates it is: =SE(H8<8,5;CONCATENAR(B8;” failed”);SE(H8<10;CONCATENAR(B8;” Oral”);CONCATENAR(B8;” passed”)))

  12. Comment by Francisco Vaz — March 2, 2009 @ 3:04 pm

    =SE(G7<8,5;CONCATENAR(A7;” Failed the exam “;SE(G7<10;CONCATENAR(A7;” goes to oral exam “;CONCATENAR(A7;” passed the exam “)))

  13. Comment by Marcio Montezinho — March 3, 2009 @ 9:40 am

    =SE(G7<8,5;CONCATENAR(A7;” Faild”);SE(G7<10;CONCATENAR(A7;” Go to oral examl”);CONCATENAR(A7;”Passed”)))

Leave a comment

You must be logged in to post a comment.