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

  • Thread starter Thread starter Guest
  • Start date Start date
=--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 :-)
------------------------------­------------------------------­----------------
 
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 said:
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?action=getinfo&userid=21419
View this thread: http://www.excelforum.com/showthread.php?threadid=483679
Click to expand...
Ron Coderre said:
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?action=getinfo&userid=21419
View this thread: http://www.excelforum.com/showthread.php?threadid=483679
Click to expand...
 
Thank you Ron and Ken. I have been wondering how to do that for years ! but it has never been critical until now. I suppose the *1 solution is pretty obvious, even to a superannuated marine engineer, but I never managed to work it out for myself. All working tickety-boo now.

Old Possum
 
Back
Top