ExcelBanter - How can you convert the false/true into 1/0 in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can you convert the false/true into 1/0 in Excel? (https://www.excelbanter.com/excel-worksheet-functions/54626-how-can-you-convert-false-true-into-1-0-excel.html)

How can you convert the false/true into 1/0 in Excel?

=--Your_formula

or

=Your_formula*1

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------

"SIMINA R" <SIMINA wrote in message
...

How can you convert the false/true into 1/0 in Excel?

Generally, 2 ways:

Either multiply by the number 1
ExampleS:
=(4=4) -Returns TRUE
=(4=4)*1 -Returns 1

=(5=4) -Returns FALSE
=(5=4)*1 -Returns 0

or

Prepend two minus signs
Example:
=(4=4) -Returns TRUE
=--(4=4) -Returns 1

=(5=4) -Returns FALSE
=--(5=4) -Returns 0

Does that help?

Regards,
Ron

--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=483679