# Need help on formula

Topic Labels: Formulas
390 1
cancel
Showing results for
Did you mean:
4 - Data Explorer

Right now we have a formula that uses percentages based on timeliness (Auto Calculated Percentage). This value is determined through a set of time between two dates. However I’d like to be able to override that for certain employees using another field like a checkbox or maybe a number field. So maybe an if statement would go in the auto calculated percentage? Like if override field is blank then use auto calculated percentage field? I can’t figure out how to do it

({Payment from Customer}*({Auto Calculated Percentage}/100))-{Admin Fee}-{Insurance Fee}-{Amount Paid to Employee}

7 - App Architect

Hi @F_M!

IF() formulas work as follows:

``````IF({condition is true/has a value},
{do this},
{otherwise do that}
)
``````

In your case you need to create your new field of choice and then add an IF() statement to your original formula. This should do it.

``````IF({name of new field of choice},
{name of new field of choice},
{Payment from Customer}*({Auto Calculated Percentage}/100))-{Admin Fee}-{Insurance Fee}-{Amount Paid to Employee}
)
``````

(You have a random ‘(’ at the beginning of your formula. Check to see if this is a mistake just in your question post or if not all of your original formula was copied. Make sure that you use the whole of the original formula in your IF()-statement for it to work as desired.)