Desestimar campo de una operación matemática si el mismo es igual a cero

AppSheet AppSheet Q&A
1

How are you! Good afternoon.

I have to do a multiplication of three fields and that multiplication is thrown in a fourth field called amount.

[Side X][Side Y][Side Z]=[Quantity]

But I need that if any of the fields is equal to 0, it is not taken into account in the multiplication.

For example:

If [Side X]=0, then calculate the following [Side Y][Side Z]=Quantity
If [Side Y]=0, then calculate the following [Side X][Side Z]=Quantity
If [Side Z]=0, then let it calculate the following [Side X]*[Side Y]=Quantity
If [side X]=0 and [side Y]=0 then calculate the following [Side Z]=Quantity
…
and so on.

I appreciate the answers

2

Perdón solo me responderé a mi mismo. Lo que hice es un IF

si un valor de la multiplicación es igual a cero, entonces que tome como valor igual a 1, ya que el 1 no altera la multiplicación.

1 Like