IwanGerbes
New Member
- Joined
- Aug 21, 2015
- Messages
- 9
Hi,
Guess it is an easy one, and sorry if it is already here, but couldn´t find it, as i don´t exactly now how to formulate it.
I´m searching for a formula to calculate in the following way:
<colgroup><col><col><col></colgroup><tbody>
</tbody>So if a shipment is 4,8 kg in Regional, it is 36 + 9x 30.
Is there a formula, which could do this? Or should i make an hidden sheet and do vlookup based on the weight to find the matching number?
Guess it is an easy one, and sorry if it is already here, but couldn´t find it, as i don´t exactly now how to formulate it.
I´m searching for a formula to calculate in the following way:
<tbody> </tbody> |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Is there a formula, which could do this? Or should i make an hidden sheet and do vlookup based on the weight to find the matching number?