Min Base Charges based on specfic criteria

[robert0803]

If F16 equals "delivery express' and the value of j17 are less than 22.50 I need the base charges to be 22.50

<style type="text/css">
.tg {border-collapse:collapse;border-spacing:0;}
.tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
.tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
.tg .tg-yw4l{vertical-align:top}
</style>
<table class="tg">
<tr>
<th class="tg-031e"></th>
<th class="tg-031e"> </th>
<th class="tg-031e">Rate Per Mile Calculator</th>
<th class="tg-031e"></th>
<th class="tg-031e"></th>
</tr>
<tr>
<td class="tg-031e"></td>
<td class="tg-031e"> </td>
<td class="tg-031e"> </td>
<td class="tg-031e"></td>
<td class="tg-031e">Pricing</td>
</tr>
<tr>
<td class="tg-031e">Delivery Express</td>
<td class="tg-031e"> </td>
<td class="tg-031e">Base Charge ►<br> Enter Base Charge</td>
<td class="tg-031e"> </td>
<td class="tg-031e">$0.00</td>
</tr>
<tr>
<td class="tg-031e">$0.00</td>
<td class="tg-031e">N/A</td>
<td class="tg-031e">Enter Miles ►<br> Enter total Miles</td>
<td class="tg-031e">25</td>
<td class="tg-031e">$0.00</td>
</tr>
<tr>
<td class="tg-yw4l">$0.00</td>
<td class="tg-yw4l">N/A</td>
<td class="tg-yw4l">Addt'l Charge ►<br> Enter Addt'l Dollars</td>
<td class="tg-yw4l"> </td>
<td class="tg-yw4l">$0.00</td>
</tr>
<tr>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"> </td>
<td class="tg-yw4l">Total Charge……….</td>
<td class="tg-yw4l">$0.00</td>
<td class="tg-yw4l"></td>
</tr>
</table>

 

[ghrain22]

if(f16="delivery express", if(j17<22.5,22.5,""),"")