Excel Convert TRUE and FALSE values to 1 and 0 in Excel by Janis Sturis June 18, 2020 Comments 0 Here is a simple trick that is not so obvious. By adding two minus signs before calculation, you can convert TRUE, FALSE into 1, 0 in Excel. =--(A2=B2) Share this:TwitterFacebookLinkedInWhatsAppPinterestRedditPocket 0 comments on “Convert TRUE and FALSE values to 1 and 0 in Excel” Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment Name * Email * Website Notify me of follow-up comments by email. Notify me of new posts by email. Post navigation Previous Post Previous Post Next Post Next Post
0 comments on “Convert TRUE and FALSE values to 1 and 0 in Excel”