Forum Discussion

Amoon Mooni's avatar
Amoon Mooni
Copper Contributor
Jan 28, 2018

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 function but it gave me either true or false!

 

could anyone advise pls !

Formulas & Functions
Need Help

2 Replies

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Jan 28, 2018

    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)