return a value

[lilly1]

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.

 

[Shane Devenshire]

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?