Late fee - Percentage or Flat Rate, Whichever is Greater

[yellowjkjeep]

Good morning all!

I am working on an Invoice reporting tool and I have everything I need done, I think, except I cannot figure out how to return a variable in Column G. What I'd like to do is return the late fee amount but how I'd like to set it up is for 5% or $35, whichever is greater. I can do either one of those, but I haven't figured out how to do both in a single cell.

I also have not yet figured out how to insert sheets on this website, but I do have a link to the project ... http://www.thistinyfarm.com/late-fees ...

Thanks in advance,
Josh

 

[JackDanIce]

Try:

=MAX(0.05*G1,35)

 

[palaeontology]

perhaps try this ...

=IF(and($I3>$D3,0.05*$F3>35),0.05*$F3,if(and($I3>$D3,35>0.05*$F3),35,""))

Kind regards,

Chris

 

[yellowjkjeep]

perhaps try this ...

=IF(and($I3>$D3,0.05*$F3>35),0.05*$F3,if(and($I3>$D3,35>0.05*$F3),35,""))

Kind regards,

Chris

Worked perfectly, changed to work with tables ... =IF(AND([@[Date Paid]]>[@[Payment Due]],0.05*[@[Amount ]]>35),0.05*[@[Amount ]],IF(AND([@[Date Paid]]>[@[Payment Due]],35>0.05*[@[Amount ]]),35,"")) ... and it's perfect! Thank you.