Answer the question
In order to leave comments, you need to log in
How to calculate the percentage relative to the largest number of digits in three cells?
https://docs.google.com/spreadsheets/d/1ZB_eROjLP1...
We display the results in E1, E2, E3, look at cells G1, G2, G3, for example, now the filling there is
11111 - this is 100%
222 - this is 60%
33 is 40%
For example, this entry:
111 is 100%
- (no twos) - 0%
333 is 100%
or so:
1111 is 100%
2 is 25%
3 is 25%
I.e. the largest number of digits is always 100%, the rest relative to it.
For example, you can get all one at a time: 1,2,3 - means 100%, 100%, 100%
Or:
1 - 50%
2 - 50%
33 - 100%
Answer the question
In order to leave comments, you need to log in
=ArrayFormula(ДЛСТР(G1:G3)/МАКС(ДЛСТР(G$1:$G$3)))
And put the percentage format, because the values will be from 0 to 1
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question