Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if condition
I am insurance underwriting assistant. I want to calculate different kind of
vehicles and different rate depends on different kinds of vehicle. Some of the vehicle I want to insure as Third party liability. Also calculation will be depends on value of the car. I calculate Value of vehicle multiply by rate + seating capacity some times 5 seats in a car some times 2 seats in a pick up and so on... calculating each record in excel separately is time wasting. I would like to do that with multiple if conditions in on record which is applicalble for every record. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if condition
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
if condition
.. ... so what are the various conditions you need to test to arrive at your
result? "Kutty" wrote: I am insurance underwriting assistant. I want to calculate different kind of vehicles and different rate depends on different kinds of vehicle. Some of the vehicle I want to insure as Third party liability. Also calculation will be depends on value of the car. I calculate Value of vehicle multiply by rate + seating capacity some times 5 seats in a car some times 2 seats in a pick up and so on... calculating each record in excel separately is time wasting. I would like to do that with multiple if conditions in on record which is applicalble for every record. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
How to use condition | Excel Discussion (Misc queries) | |||
Condition 1 overules condition 2? | Excel Worksheet Functions | |||
Condition sum | Excel Worksheet Functions | |||
if condition, do something, do nothing | Excel Discussion (Misc queries) |