Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF Formula that has 2 possibilities?

Topic Labels: Formulas
1224 2
cancel
Showing results for 
Search instead for 
Did you mean: 
joe_hayes
4 - Data Explorer
4 - Data Explorer

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”

2 Replies 2

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)

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