Forum Discussion
Nested IF Function not working
Hi I have a column of temperature and the percentage. I want the percentage column (D) is based on the temperature column (C) where: IF 30=7 31=7 32=9 33=9 34=11 35=1...
Neruu See if the attached workbook does what you need. I prefer to use a lookup table over hard-coding limits in a formula with nested IF functions.
Make sure that the temperatures are numbers, since when I copied the data into a workbook, I got texts with a trailing space. Something like "30 ".
With your original formula, you were looking for "30" which is not equal to "30 ". Hence, it always returned zero.