Skip to main content

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)

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:

 

Terms & ConditionsAccessibility statement