| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
return a value
I am creating a spreadsheet to return a medical premium based plan enrolled,
scheduled hours and a salary range. I would like to type in the medical plan name in cell a1 salary in a2 and scheduled hours in a3. based on these three conditions I would like to return the employee's premium. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
return a value
Hi,
Are we supposed to make up any formula we want? You need to tell us how these three peices of info tell you the premium, then we can design a formula. What are scheduled hours? What salary range? 1-2 dollars, or $20-$5467 or what? -- If this helps, please click the Yes button Cheers, Shane Devenshire "lilly1" wrote: I am creating a spreadsheet to return a medical premium based plan enrolled, scheduled hours and a salary range. I would like to type in the medical plan name in cell a1 salary in a2 and scheduled hours in a3. based on these three conditions I would like to return the employee's premium. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
| Return only if same | Excel Worksheet Functions | |||
| How to get #value! to return a value of 0? | New Users to Excel | |||
Hybrid Mode
