How can I create a formula that will return the greater of two calculations

[amjbrett]

I am trying to calculate a monthly fee using the days360 function with a beginning and end date, but would like the formula to display at least a six month fee or the actual amount if greater than the six month calculation.

date in date out amount due rate
10/10/2017 3/31/2018 $182.40 $32.00



Formula for amount due is: =DAYS360(A2,B2)/30*D2

Any help you can provide would be greately appreciated.
I am using Excel 2007

Ann

[shg]

=max(days360(a2, b2), 180) / 30 * d2

[amjbrett]

Thanks for the quick reply....ever so grateful. :-)
I should have joined the forum a long time ago.

[shg]

You're welcome.