apply the excel roundown formula in this one =[@[Qtd Total ]]/[@[Gramas Diaria]]
- User
apply the excel roundown formula in this one =[@[Qtd Total ]]/[@[Gramas Diaria]]
- Assistant
To apply the Excel
ROUNDDOWNformula 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
0means 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!
- User
=ROUNDDOWN([@[Qtd Total ]]/[@[Gramas Diaria]], 0)
adjust it so gramas diarias is multiplying by Qdd por Porcao
- 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.