The task is as follows: there are three cells, each has a numeric value (the first number in the first cell, the second number in the second cell, and the result in the third cell). Is there any formula that compares the values ​​in the first and second cells and divides the larger number into a smaller one, and the result in the third cell is written.

    1 answer 1

    =МАКС(A1:B1)/МИН(A1:B1) =ЕСЛИ(МАКС(A1:B1)=A1;A1/B1;B1/A1) =МАКС(A1/B1;B1/A1)

    We still need to check that there is no division by zero error:

     =ЕСЛИ(МИН(A1:B1)=0;"ошибка";МАКС(A1:B1)/МИН(A1:B1)) =ЕСЛИОШИБКА(МАКС(A1:B1)/МИН(A1:B1);"нельзя!")