% formula

[Sabcalvary55]

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 · Accepted solution]

@Sabcalvary55 

=A1-MAX(A1*0.04,4)

You can try this formula.

 

[#3]

Thank you!