Formula not producing anything. What did I do wrong?
I have spaced this out so it is easier to read. {Bank / Lender Owned?} is a check mark. If it is not checked, I want to base the answer from the AOC field. If it is checked, I want to base the answer off the B2B field. Any possible result should either be 500 or 1000.
UPDATE: Okay, I figured it out. The SWITCH function doesn’t seem to like Boolean Check Boxes.
Instead, I did this:
IF({Bank / Lender Owned?}=0,IF({(AOC) 1st Offer}<100000,500,1000),IF({(B2B) 1st Offer}<100000,500,1000))
UPDATE: Okay, I figured it out. The SWITCH function doesn’t seem to like Boolean Check Boxes.
Instead, I did this:
IF({Bank / Lender Owned?}=0,IF({(AOC) 1st Offer}<100000,500,1000),IF({(B2B) 1st Offer}<100000,500,1000))
Nor should it.
Switch() is not a good choice for boolean evaluations. You are overloading your formula with the Switch method which is suited for many possible values. Booleans, on the other hand, are binary values and performant operations can occur well inside the lighter and more efficient IF() formula.
> As it turns out, the switch statement is faster in most cases when compared to if-else , but significantly faster only when the number of conditions is large. The primary difference in performance between the two is that the incremental cost of an additional condition is larger for if-else than it is for switch.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
