About Us

ExcelBanter AI

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(condition1, condition2))

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:

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Menu

About Us