Hi,
I am needing help creating a formula.
It would be if (15% referral says no then it would calculate the daily rate times 15%), if (15% referral says yes then it would be daily rate)
Solved
Help with if then formula
+4Best answer by Ben_Young1
Hey @AmandaC1121!
Is this along the lines of what you're looking for?
IF(
{15% Referral} = "No",
{Daily Rate} + ({Daily Rate} * .15),
IF(
{15% Referral} = "Yes",
{Daily Rate}
)
)
It's worth noting that this formula will return nothing if the 15% Referral field returns empty.
If you'd like for the formula to default to just returning the Daily Rate, you could use this:
IF(
{15% Referral} = "No",
{Daily Rate} + ({Daily Rate} * .15),
{Daily Rate}
)You'll want to confirm that your formula field's formatting configuration is set properly:
+22Hey @AmandaC1121!
Is this along the lines of what you're looking for?
IF(
{15% Referral} = "No",
{Daily Rate} + ({Daily Rate} * .15),
IF(
{15% Referral} = "Yes",
{Daily Rate}
)
)
It's worth noting that this formula will return nothing if the 15% Referral field returns empty.
If you'd like for the formula to default to just returning the Daily Rate, you could use this:
IF(
{15% Referral} = "No",
{Daily Rate} + ({Daily Rate} * .15),
{Daily Rate}
)You'll want to confirm that your formula field's formatting configuration is set properly:
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.