Función para encontrar la cantidad mínima exceptuando cero

  • arangones15
    Fecha de consulta 17 de mayo de 2024, 17:00

    Hay alguna manera de obtener la cantidad mínima pero excluyendo el cero?

    Ej. la cantidad mínima si ponen 0,1,4,1,1,2,5 sería 1

    En Excel la función es =MINIFS(CAMPO NUMÉRICOCAMPO NUMÉRICO , ">0")

  • Afzal Jotform Support
    Fecha de respuesta 17 de mayo de 2024, 19:14

    Hi Aranzazu,

    Thank you for reaching out to Jotform Support. I am currently using a translation to provide assistance, but if you want to get assistance in Spanish language, we can forward your request to our Spanish Support Team, but please note that it may take longer to receive a response.

    It seems you are looking to find the smallest number excluding zero. Advanced formulas can be used both on the form builder and the submission table. Please explain more about the use case and we'll do a more in-depth investigation and work on finding a solution.

    Once we hear back from you, we'll be able to move forward with a solution.