hi all,
i have a situation that i need to write a formula to pick the prameter which is smaller, but ignore 0s.
so for instance, if A is 8 and B is 6, i want it to be B, but in most cases B is zero so i want it to be A.
how can i make a exception for 0 ?
Gelöst! Gehe zur Lösung
Gelöst von ToanDN. Gehe zur Lösung
@arsham wrote:
hi all,
i have a situation that i need to write a formula to pick the prameter which is smaller, but ignore 0s.
so for instance, if A is 8 and B is 6, i want it to be B, but in most cases B is zero so i want it to be A.
how can i make a exception for 0 ?
if (and (B < A, B > 0), B, A)
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.