How would one use IF function to determine the following please help...Thanks
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
SECONDARY TRANSPORT RATE: | 251 TO 400 KM & >400 $ | 24 PER MT PER KM | |||
SECONDARY TRANSPORT RATE: | 101 TO 250 KM $ | 25 PER MT PER KM | |||
SECONDARY TRANSPORT RATE: | 31 TO 100 KM $ | 25 PER MT PER KM | |||
SECONDARY TRANSPORT RATE: | 11 TO 30 KM $ | 25 PER MT PER KM | |||
SECONDARY TRANSPORT RATE: | <=10 $ | 600 PER MT | |||
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>