IF Formula that has 2 possibilities?

I need help with an IF Formula. I have the following
“Category” Field - Single Select
“Est Rate” Field - number currency
“Rate to Quote” Field - number currency (where I want the formula)

Looking for a formula that does the following:

If the the “Category” is NOT "Wedding, then “Rate to Quote” = “Est Rate” + 25%, If “Category” is “Wedding”, “Rate to Quote” = “Est Rate”

The IF() function works like this: IF([scenario],[value if scenario applies], [value if scenario doesn't apply])

Therefore, your formula would be:
IF({Category}='Wedding', {Est Rate}, {Est Rate} * 1.25)

1 Like

Awesome!! Thank you!! I was trying to play around with it and was hitting a wall lol