Can I get information

K

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula 1
if condition 2
Going to a "set" range 3
Help with Cell Formula 2
Time Format 1
If Statement Help!! 9
CheckBox Help 6
beginner sql query 0

Top