Skip to content
TheChatArchiveThe Chat Archive
gpt-4.1-mini-2025-04-14· OpenAIAi2 WildChat-4.8M (AI2)

apply the excel roundown formula in this one =[@[Qtd Total ]]/[@[Gramas Diaria]]

  1. User

    apply the excel roundown formula in this one =[@[Qtd Total ]]/[@[Gramas Diaria]]

  2. Assistant

    To apply the Excel ROUNDDOWN formula to your existing formula:

    Original formula:

    =[@[Qtd Total ]]/[@[Gramas Diaria]]
    

    Using ROUNDDOWN, for example, to round down the result to 0 decimal places (i.e., round down to an integer), you would write:

    =ROUNDDOWN([@[Qtd Total ]]/[@[Gramas Diaria]], 0)
    

    Explanation:

    • The first argument is your original division formula.
    • The second argument 0 means round down to zero decimal places (integer).

    If you want to round down with a different number of decimal places, change the second argument accordingly.

    Let me know if you want it rounded down to some decimal places!

  3. User

    =ROUNDDOWN([@[Qtd Total ]]/[@[Gramas Diaria]], 0)

    adjust it so gramas diarias is multiplying by Qdd por Porcao

  4. Assistant

    Sure! If you want to adjust the formula so that instead of just dividing by [@[Gramas Diaria]], you divide by the product of [@[Gramas Diaria]] and [@[Qdd por Porcao]], the formula becomes:

    =ROUNDDOWN([@[Qtd Total ]]/([@[Gramas Diaria]]*[@[Qdd por Porcao]]), 0)
    

    Explanation:

    • [@[Gramas Diaria]]*[@[Qdd por Porcao]] multiplies the two columns.
    • Then divide [@[Qtd Total ]] by that product.
    • Finally, ROUNDDOWN(..., 0) rounds the result down to the nearest integer.