Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple IF function
Hi,
I'm trying to create a Life Insurance Calculator within Excel. I've already done a VLOOKUP to get the Relevant Premium Rate, but now I need to be able to reference back to them given the option. The four options available a 1. Male Non-Smoker 2. Male Smoker 3. Female Non-Smoker 4. Female Smoker For example: 1. If Male AND a Non-Smoker, I want to refer to Cell A1 2. If Male AND a Smoker, I want to refer to Cell A2 3. If Female AND a Non-Smoker, I want to refer to Cell A3 4. If Female AND a Smoker, I want to refer to Cell A4 Any help is much appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple function is it even possible | Excel Worksheet Functions | |||
Multiple IF Function | Excel Discussion (Misc queries) | |||
Multiple results from multiple criteria using IF function | Excel Discussion (Misc queries) | |||
Multiple Sheet, Multiple Criteria Look-Up Function Help | Excel Worksheet Functions | |||
Multiple OR function | Excel Worksheet Functions |