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...
Thank you Riny_van_Eekelen and Patrick2788 for the feedback.
Much appreciated for the solution given. I have managed to use the LOOKUP and SWITCH function on different date and time.
Much appreciated for the solution given. I have managed to use the LOOKUP and SWITCH function on different date and time.