tycasey17
Board Regular
- Joined
- Sep 26, 2013
- Messages
- 93
- Office Version
- 2019
- 2016
- Platform
- Windows
I assumed that the following statement would recognize any text (either numbers or letters) and have the return of "1" or "0" for true or false respectively.
Statement: =IF(A1="*",1,0) and I have tired =IF(A1=*,1,0) Niether have worked
<tbody>
</tbody>
Statement: =IF(A1="*",1,0) and I have tired =IF(A1=*,1,0) Niether have worked
Text | 1 |
[blank] | 0 |
<tbody>
</tbody>