Thread: Two Formulas

Is there a lookup formula that looks up a table then brings back a value if
it is between that range. For example, Age range 21-25 = $10.00. I want to
look find how much age 23 is, but I don't want to input 21,22,23,24,25 =
$10.00 in the table.

Also, I need to lookup an x and y value and bring back a value. For example,
age on y axis and amount of coverage on x axis bring back value when they
meet.

have a look at IF and AND
=if(and(ag>=21,ag<=25),10,0)

--
Don Guillett
SalesAid Software
donaldb@281.com
"Lindsay" <Lindsay@discussions.microsoft.com> wrote in message
news:19D3FA7B-5FBD-47DC-841B-FB14D907C24F@microsoft.com...
> Is there a lookup formula that looks up a table then brings back a value
if
> it is between that range. For example, Age range 21-25 = $10.00. I want to
> look find how much age 23 is, but I don't want to input 21,22,23,24,25 =
> $10.00 in the table.
>
> Also, I need to lookup an x and y value and bring back a value. For
example,
> age on y axis and amount of coverage on x axis bring back value when they
> meet.