Help

Help with if then formula

Topic Labels: Formulas
Solved
Jump to Solution
444 1
cancel
Showing results for 
Search instead for 
Did you mean: 
AmandaC1121
5 - Automation Enthusiast
5 - Automation Enthusiast

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)

1 Solution

Accepted Solutions
Ben_Young1
11 - Venus
11 - Venus

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}
    )
)

Snag_14ec9a0.png

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:

Snag_151a040.png

See Solution in Thread

1 Reply 1
Ben_Young1
11 - Venus
11 - Venus

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}
    )
)

Snag_14ec9a0.png

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:

Snag_151a040.png