Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help creating a formula, pulling from a set of static numbers.
I have my worksheet set up to average a set of 8 numbers. I need a forumal
that will give a specific result based on that average. I have a static list of numbers so I know what needs to go in for each average... I just don't know how to make a formula that will let the worksheet do this for me. For example I have an average number of 16. I need a forumla that will tell me that if the average is between 16 and 20 I need 5 in the next column. My averages will go from 1 to 100 and the number I need for these goes from 2 to 24.... HELP! |
#2
|
|||
|
|||
=LOOKUP(AvgValue,Table)
where Table refers to a range that associates 1 to 100 to 2 to 24 in an ascending order. "James" wrote in message ... I have my worksheet set up to average a set of 8 numbers. I need a forumal that will give a specific result based on that average. I have a static list of numbers so I know what needs to go in for each average... I just don't know how to make a formula that will let the worksheet do this for me. For example I have an average number of 16. I need a forumla that will tell me that if the average is between 16 and 20 I need 5 in the next column. My averages will go from 1 to 100 and the number I need for these goes from 2 to 24.... HELP! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
Displaying numbers used in formula | Excel Discussion (Misc queries) | |||
Formula to calculate only the negative numbers | Excel Worksheet Functions | |||
Display numbers only, no text formula | Excel Worksheet Functions | |||
how to build a formula to match numbers in 2 columns with the equ. | Excel Worksheet Functions |