Help

Re: IF Formula that has 2 possibilities?

740 0
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