Excel

Help! I do not know much about excel equations and have a pretty complicated task to complete by Friday...

I have a chart of rates. The rates are determined by 6 parameters. I need to link an excel sheet so that the answers to the parameters pick the correct rate from the rate sheet.
The parameters include: plan A, B, or C, Smoker or non-smoker, male, or female and then 11 different age categories.

I need a very basic and detailed explanation of how this might be possible from anyone willing to help!


I have now attached the sheet that needs the equations. Sheet 1 is the chart and sheet 2 is the sheet where parameters are selected and the rate appears when we figure out the right equation.

Your attachement didn't come across

Please resend and then send me s Private message as i don't look here very often and i will try to help you if you still need help.

S-

My attachment is in Excel format and it wouldn't let me attach it. Maybe I could email it to you?

Can you zip it and then attach it?

S-

Sorry I don't know how to zip, I tried to save as and select zip but it doesn't give me a zip choice. and I tried HELP but it doesn't want to tell me either.

ok I got it, its zipped! I'll post it

here is the file zipped

Heather

Here is the deal, What you want to do I don't think is possible, at least not easy. You hve two choices.

Enter you data in a table format (see below) and write a macro that will look at your criteria and then search through the table for the right cost. If you only had one criteria you could have used a built in function, but alas you don't.

Or
Put your data in MS Access database and write queries that will do the work for you.

My preference is to use Access, it will provide more flexibility in the long run. Neither option is easy to do, if you are not comfortable with some code.

Sorry I could be more help for you.

S-

Table example:

Plan M/F Smoker Age Cost
A M Y 0 1270
A M Y 25 1370
A M Y 30 1470
A M Y 35 1570
A M Y 40 1670
A M Y 45 1770
A M Y 50 1870
A M Y 55 1970
A M Y 60 2070
A M Y 65 2170
A M Y 70 2270
A M Y 75 N/A

Ok, thanks for trying! the thing is that it needs to search for age bands--not just 50 or 55 but it could be 52 or 53 and it would need to find the right rate for this. Anyway...I think this is something for my IT department so this is what I'll go for. I've never even recorded a macro..something I'd like to learn and don't know the first thing about Access. Thanks for the help anyway!

You are looking at it from a limitied point of view.

You look at it like this the last record where the age is less then my age-criteria break.


At any rate, here is another forum to post your question in and maybe someone there may have another alternative that I can't think of.

http://www.dbforums.com/f243/

Good Luck

S-