M
Mojo
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!
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!