View original (French)

Grade out of 20

Solved
nernono1 Posted messages 2 Status Member -  
Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   -
Hello,
in Excel, how can I make it so that in the cell there is a result and it says "/20"
I’m looking to mix numbers and letters in the same cell
thank you

2 answers

  1.
    ccm81 Posted messages 11033 Status Member 2 434
     
    Hello

    or if you want to keep the numerical value of the cell
    Format/cell/Custom
    00,0"/20"

    Have a good continuation
    4
  2. Ricky38 Posted messages 5776 Registration date   Status Contributor Last intervention   1 463
     
    Hello,

    for example, if in A1 you have 10
    in B1 you have 5
    and in C1 you want to see the sum of A1 and B1 over 20
    In C1 you put this formula =SUM(A1:B1)&"/20"
    which will give you 15/20 in C1

    There you go

    --
    Every problem has a solution... you just need to be persistent.
    0
    1. nernono1 Posted messages 2 Status Member
       
      Good evening, how to make the symbol &
      thank you
      0
    2. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
       
      in principle, it's the [1] key in lowercase...
      0