Oct 02, 2019 05:13 PM
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”
Oct 02, 2019 05:24 PM
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)
Oct 02, 2019 05:26 PM
Awesome!! Thank you!! I was trying to play around with it and was hitting a wall lol