A
A
Alina Shah2021-09-27 20:11:51
Google Sheets
Alina Shah, 2021-09-27 20:11:51

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

1 answer(s)
G
Grigory Boev, 2021-09-28
@Shah_Alina

=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 question

Ask a Question

731 491 924 answers to any question