Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

# IF Field = x, then = \$5.00, OR IF Field=y, then = \$1.00

Topic Labels: Formulas
Solved
528 3
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Can someone help my brain wrap around this type of formula?
I’m trying to get different amounts to populate based on what is selected in a different field. For example)
Field 1 is State
Trying to get Field 2 to calculate: if Field 1 is Missouri, then Field 2 should equal \$2.00, OR If Field 1 is Illinois, then Field 2 should equal \$1.00

1 Solution

Accepted Solutions
13 - Mars

How manny variables do you have in the State field?

I think a Switch formula would be better since you dont have a “Formula” that needs calculations.

So it would be SWITCH({State}, “Illinois”, 1, “Missouri”, 2)

Since in typing from my phone, the quotation marks are not correct, please change them in your formula to the correct ones)

Hope that helps.

3 Replies 3
13 - Mars

How manny variables do you have in the State field?

I think a Switch formula would be better since you dont have a “Formula” that needs calculations.

So it would be SWITCH({State}, “Illinois”, 1, “Missouri”, 2)

Since in typing from my phone, the quotation marks are not correct, please change them in your formula to the correct ones)

Hope that helps.

5 - Automation Enthusiast

SWITCH worked, you’re amazing!

My pleasure :slightly_smiling_face: glad it worked