Choose Value on Conditional basis

Giganews Newsgroups
Subject: Choose Value on Conditional basis
Posted by:  Murtaza (NoEma…@Please.com)
Date: Mon, 17 May 2004

Scenario:
======
I have a to calculate incentive of about 100 employees based on their %Ach
Column, we have already made a *Table of Incentive Slots* i.e.if %Ach falls
between (>=95% to <=98%) he/she will be qualified for $6500 ...and so on

Required:
=======
I need a forumla or way to easily calculate the incentive amount of each
individual.

Details:
=====
The Layout of working sheet is below:

Name        Title    %Ach    IncentiveAmount
Mr. xyz      abc      98.7            ?? (this should be equal to 13000)

The layout of *Table of Incentive Slots* is below:

%AchMin        %AchMax        Incentive Amount
>=95%            <=98%                    6500
>98%              <100%                    13000

Any help willl be highly appreciated
Murtaza

Replies