% formula

New Contributor

I need to create a formula for service that gives 4% or $4.00 whichever is greater deducted from cost of service. Can I do that & if so how do I write it. Example: service is $60.00. deduct 4% or $4.00 whichever is higher amount. Thank you. 

2 Replies
best response confirmed by Hans Vogelaar (MVP)



You can try this formula.

percent formula.JPG 

Thank you!