return a value

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.
 
S

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Row Hide Or 0 value 2
Calculating combination of text occurances 5
Multiplying the contents of two cells a variable number of times 1
Reference cells in seperate worksheet 3
Array Formula? 1
date calcuations 4
Multiple lookup values and adding multiple rates across together 5
Using 'AND' logic in a SUMIF statement 2

Top