Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula not producing anything. What did I do wrong?

Topic Labels: Formulas
1557 2
Showing results for 
Search instead for 
Did you mean: 

Formula not producing anything. What did I do wrong?

formula 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.

2 Replies 2

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.