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.
>