return a value

  • Thread starter Thread starter lilly1
  • Start date Start date
L

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.
 
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?
 
Back
Top