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

[Leah_Huelsing]

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

[Mohamed_Swella1 · Accepted solution]

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.

[Leah_Huelsing]

SWITCH worked, you’re amazing!

[Mohamed_Swella1]

My pleasure :slightly_smiling_face: glad it worked