S
S
SemenDemon2020-02-06 19:06:52
Mathematics
SemenDemon, 2020-02-06 19:06:52

How to round a number relatively?

Perhaps the question is closer to fuzzy sets.

10
20
30
50
100
150
200
300
500
700
1000
1250
1500
2000
...
1.000.000
1.050.000
1.100.000

_

Answer the question

In order to leave comments, you need to log in

1 answer(s)
H
hint000, 2020-02-07
@SemenDemon

=ROUND(A2/10^ROUND(LOG10(A2)*B$1))*10^ROUND(LOG10(A2)*B$1)

5e3cbfc2a8e82307022723.png
Is that enough? The parameter in the top line (0.5..0.85) is "the level of a person's love" :)
PS By the way, F4 has a curious artifact. So 0.85 is too high a level of love.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question