Help

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
Jump to Solution
528 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Hi @Leah_Huelsing,

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.

See Solution in Thread

3 Replies 3

Hi @Leah_Huelsing,

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.

SWITCH worked, you’re amazing!

My pleasure :slightly_smiling_face: glad it worked