Forum Discussion
Jeffry Christopher
Jul 03, 2017Copper Contributor
Problem with IF function
Please refer to the attached file. I need the worksheet to work in this way. If the calculated duration is more than 56, the value in the 'COLD' row must increase by 1. If the calculated durat...
Detlef_Lewin
Jul 03, 2017Silver Contributor
Hi
=--(E5>56) =--(MEDIAN(10,56,E5)=E5) =--(E5<10)