You are viewing limited content. For full access, please sign in.

Question

Question

Travel Reimbursement Form - Tip Calculation

Laserfiche Forms How To
Updated two days ago
asked on January 14

How can I configure a Laserfiche Form to ensure that if an employee enters a tip amount exceeding 20% of the meal's total, the excess is not calculated or included in the overall total that will be reimbursed? Is this functionality achievable within Laserfiche Forms?

0 0

Replies

replied two days ago • Show version history

You could probably use the IF function in a calculation.

IF(booleanValue, value1, value2)

=Meal + IF(Tip>Meal*0.2, Meal*0.2, Tip)

OR

=SUM(Meal, IF(Tip>MULT(Meal,0.2), MULT(Meal,0.2), Tip))

 

 

4 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...