Announcement

Collapse
No announcement yet.

Formular for multiplicating amount based on length of list

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Formular for multiplicating amount based on length of list

    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:

    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?

  • #2
    i got it.
    Code:
    array\length(LIST)
    was the way to go

    Comment

    Working...
    X