Posted to microsoft.public.excel.worksheet.functions

HRLADY

Posts: n/a

Calculating rate based on age ranges

I have a insurance spreadsheet that I need to calculate the premium amount
based on the age of the employee. The rates are determined by an age range.

My spreadsheet is like this:
Age Premium
50 ?
30 ?

The rates a
under 30 .05/1000
30-34 .07/1000
35-39 .09/1000
40-44 .14/1000
45-49 .25/1000
50-54 .42/1000
etc

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculating cells based on dates	Superchikn	Excel Worksheet Functions	1	March 17th 06 09:07 PM
Formula to sum various cells based on rate factor	Frick	Excel Worksheet Functions	0	March 8th 06 09:16 PM
Named Ranges	Joe Gieder	Excel Worksheet Functions	2	February 16th 06 01:31 AM
Calculating Interest where rate changes per quarter	Dean Strudwick	Excel Discussion (Misc queries)	1	December 6th 04 11:36 PM
Problem with graph ranges	No Such Luck	Charts and Charting in Excel	6	December 3rd 04 01:09 PM

All times are GMT +1. The time now is 06:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us