Can I get information

[Kutty]

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.

 

[Art]

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.

 

[Oldroboman]

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