I want to autocalculate in excel as follows :
I am working an insurance company. I want to calculate automatically list
of vehicles' as per the value of each vehicle. The rate will be different
depends on type of vehicle. e.g:

Type of vehicle: Bus
value : SR.150,000
Rate: 4%
Value X Rate
If Third party Liability Insurance there will be a fixed Premium. This
should calculate in if condition. Can I calculate these with multiple if
condition in one line?
Because I can do this in one line, then I can drag the same for all lines
even if there is hundreds of thousands of different types and different rates.