Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2000 Question
I have 28 cells in a column with imported percentage (moisture) from a
database. I want to create another column that calculates maximum drying temperature (for corn dryer) based on the percent moisture. Example: If cell C2 = .10, max temp would be 105. If cell C2 = .34, max temp would be 94, etc. Possible range of moisture percentage would be .10 to ..40. Max temp would go from 94 to 105. I was able to figure this out in Excel 2007 easy enough using Lookup (lookup (cell), {percent, percent, percent, "105","104","103"} etc. Struggling to get Lookup to work like that in 2000. HELP! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2000 Question
=LOOKUP(B1,{.1;.2;.3;.4},{102;101;100;99}) HTH, Bernie MS Excel MVP "Mojo" wrote in message ... I have 28 cells in a column with imported percentage (moisture) from a database. I want to create another column that calculates maximum drying temperature (for corn dryer) based on the percent moisture. Example: If cell C2 = .10, max temp would be 105. If cell C2 = .34, max temp would be 94, etc. Possible range of moisture percentage would be .10 to .40. Max temp would go from 94 to 105. I was able to figure this out in Excel 2007 easy enough using Lookup (lookup (cell), {percent, percent, percent, "105","104","103"} etc. Struggling to get Lookup to work like that in 2000. HELP! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 column question | Excel Discussion (Misc queries) | |||
Excel 2000 Date Question | Excel Worksheet Functions | |||
Excel 2000 Track Changes Question. | Excel Discussion (Misc queries) | |||
Excel 2000 Question | Excel Worksheet Functions | |||
Question about XML functionality in Excel 2000/XP | Setting up and Configuration of Excel |