if (A > B, B, A) but ignore 0

[arsham]

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 ?

[ToanDN · Accepted solution]

---

@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) 

[arsham]

in @ToanDN  we trust! 

thanks!