Help

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

Topic Labels: Formulas
Solved
Jump to Solution
864 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Leah_Huelsing
5 - Automation Enthusiast
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
Mohamed_Swella1
13 - Mars
13 - Mars

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
Mohamed_Swella1
13 - Mars
13 - Mars

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