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.

Suppose I have the following in rows 1-4 of cells A-C

Vehicle Rate Fixed Rate
Bus .4 1000
Car .3 500
Truck .5 2000

In Rows 7-8 in columns A-D I have:

Type 3rd party Value Calculation
Bus FALSE 1000 =VLOOKUP(A8,A2:C4,B8+2)*IF(B8,1,C8)

I think this might be what you're looking for.


"Kutty" wrote:

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.

go onto chip pearsons site www.cpearson.com and look at the SUMIF, MULITPLE
CRITERIA page, that will do it bette


"Kutty" wrote:

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.