Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 97
Default Converting TRUE/FALSE from AND to number, like 1 or 0

I would like to have results of AND() appear as 1 or zero instead of TRUE or
FALSE. I tried to use IF to check for true or false but for some reason this
doesnt work. Can someone help?

Thanks,
Joe M.
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Converting TRUE/FALSE from AND to number, like 1 or 0

Hi Joe,

Sure, I can help you with that. To convert TRUE/FALSE results from an AND function to 1 or 0, you can use the following formula:

Formula:
=--(AND(condition1condition2)) 
The double negative sign (--) before the AND function converts the TRUE/FALSE result to a number. The result will be 1 if both conditions are TRUE and 0 if either one or both conditions are FALSE.

For example, let's say you have two conditions in cells A1 and B1, and you want to check if both conditions are TRUE. You can use the following formula:
  1. Formula:
    =--(AND(A1="condition1"B1="condition2")) 

If both conditions are met, the result will be 1. If either one or both conditions are not met, the result will be 0.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default Converting TRUE/FALSE from AND to number, like 1 or 0

Try it like this:

=--AND()

Or:

=AND()+0

--
Biff
Microsoft Excel MVP


"Joe M." wrote in message
...
I would like to have results of AND() appear as 1 or zero instead of TRUE
or
FALSE. I tried to use IF to check for true or false but for some reason
this
doesnt work. Can someone help?

Thanks,
Joe M.



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default Converting TRUE/FALSE from AND to number, like 1 or 0

Hi,

Simply multiply your and formula by 1 to turn true/false into 1 or zero

=AND(A1=1,B1=1)*1

Mike

"Joe M." wrote:

I would like to have results of AND() appear as 1 or zero instead of TRUE or
FALSE. I tried to use IF to check for true or false but for some reason this
doesnt work. Can someone help?

Thanks,
Joe M.

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Converting TRUE/FALSE from AND to number, like 1 or 0

Multiply by 1:

=AND(1=1,2=2)*1

--
Gary''s Student - gsnu200856


"Joe M." wrote:

I would like to have results of AND() appear as 1 or zero instead of TRUE or
FALSE. I tried to use IF to check for true or false but for some reason this
doesnt work. Can someone help?

Thanks,
Joe M.



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Converting TRUE/FALSE from AND to number, like 1 or 0

=--(and(yourexpressionhere))

The first minus sign will convert True to -1 and the second will change it to 1.



Joe M. wrote:

I would like to have results of AND() appear as 1 or zero instead of TRUE or
FALSE. I tried to use IF to check for true or false but for some reason this
doesnt work. Can someone help?

Thanks,
Joe M.


--

Dave Peterson
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Converting TRUE/FALSE from AND to number, like 1 or 0

=--AND(A1,B1)
but IF should work if you want to use it
=IF(AND(A1,B1),1,0) or (adding unnecessarily)
=IF(AND(A1,B1)=TRUE,1,0)
--
David Biddulph

Joe M. wrote:
I would like to have results of AND() appear as 1 or zero instead of
TRUE or FALSE. I tried to use IF to check for true or false but for
some reason this doesnt work. Can someone help?

Thanks,
Joe M.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu LunaMoon Excel Discussion (Misc queries) 9 July 29th 08 12:28 AM
Any number above 15 returns false when it should be true tlaurie777 Excel Worksheet Functions 2 September 26th 07 05:02 PM
Search for 2 true arguments and return true or false David Excel Discussion (Misc queries) 3 July 15th 06 10:18 AM
Function to return True/False if all are validated as True by ISNU Tetsuya Oguma Excel Worksheet Functions 2 March 15th 06 10:28 AM
Convert TRUE/FALSE results to a number pomalley Excel Worksheet Functions 5 March 16th 05 05:45 PM


All times are GMT +1. The time now is 03:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"