Grade out of 20
Solved
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
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
-
Hello
or if you want to keep the numerical value of the cell
Format/cell/Custom
00,0"/20"
Have a good continuation -
ContributorHello,
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.
