Yes or No in one field to a 1 or 0 in another

Question

I have a column titled Yes/No.&nbsp; The only results in that field will be Yes or no.
I added another column titled # of Points.

I want to be able to convert the Yes or No in the other field to a 1 or 0 in the # of Points field.&nbsp; I have searched and am not coming up with anything.&nbsp; I know how to get a number from 1 field to a number in another field, but not text to number.&nbsp;&nbsp;------------------------------Jon Hurtado------------------------------

heatherdelozie2 · Answer

Hi Jon,
You could do the following If statement in either a formula text or formula numeric field named # of Points: &nbsp;
&nbsp; &nbsp; If([Yes/No]= "Yes", 1, 0)
In the above formula, the [Yes/No] should be replaced with whatever your field name is.
No need to worry about converting from text to numeric with this statement.
I tested this out and works splendidly!

Thanks,
Heather D
------------------------------Heather Delozier------------------------------

Forum Discussion

Yes or No in one field to a 1 or 0 in another

1 Reply