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)
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.