Forum Discussion
Amoon Mooni
Jan 28, 2018Copper Contributor
Excel formula/function question
Dear prof
I'd like to formulate my input to be interpreted in the cell as either 0 or 1. where 1 is the interpretation of the values are ranked between 50 and 60 and 0 if otherwise. I tried IF...
Detlef_Lewin
Jan 28, 2018Silver Contributor
Amoon,
there are many ways to convert a boolean value into a numerical value.
=N(Your_Formula) =--(Your_Formula) =1*(Your_Formula) =0+(Your_Formula)
Amoon Mooni
Jan 28, 2018Copper Contributor
Many Thx Detlef for your response .