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
Solved
IF Field = x, then = $5.00, OR IF Field=y, then = $1.00
Best answer by Mohamed_Swella1
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.
This topic has been closed for replies.
+17Hi @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.
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!
+17SWITCH worked, you’re amazing!
My pleasure :slightly_smiling_face: glad it worked
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.