Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Two Formulas
have a look at IF and AND
=if(and(ag=21,ag<=25),10,0) -- Don Guillett SalesAid Software "Lindsay" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |