Hi y'all,
i would like to write a formula that gives me a float multiplied by the length of a multi-enum-cell. The end result should be a float again of course.
For better understanding, the use case is as follows:
In cell one there is a float representing an annual contribution to a project.
In the multi-Enum-Cell, the years in which a contribution is to be paid are checked.
The third cell should be a float that represents the product of the annual contribution from cell one and the length of the multi-Enum-Cell.
Example:
How do i do this? Is there a function like "length()" or something simmilar?
i would like to write a formula that gives me a float multiplied by the length of a multi-enum-cell. The end result should be a float again of course.
For better understanding, the use case is as follows:
In cell one there is a float representing an annual contribution to a project.
In the multi-Enum-Cell, the years in which a contribution is to be paid are checked.
The third cell should be a float that represents the product of the annual contribution from cell one and the length of the multi-Enum-Cell.
Example:
Code:
"cell one": "200$" "multi-enum": "2023,2024,2025" "cell three": "600$"
How do i do this? Is there a function like "length()" or something simmilar?
Comment