MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Boolean if problem


Posted by Mark P. on July 10, 2000 6:08 AM

Please help I need to compare 12 cells using boolean formula; if the condition =TRUE I need to get blank cell (" "). Ex.
A1=3; A2=3 in C1 I have the formula =(" ")*(A1=A2) but it does not work, I get error result. Thanks.


Posted by Ryan on July 10, 0100 6:27 AM

Here is the proper sytax for an IF statement:

IF(A1=A2,"",[Else]). You'll have to nest a couple IF statements to compare all 12 cells. But it can be done. Hope this helps.

Ryan

Posted by Mark P. on July 10, 0100 6:46 AM

I need the boolean approach to avoid the 7 limit

Thanks Ryan but I need the boolean formula =("")*(A1=A2) etc.

Posted by Jaime on July 10, 0100 8:40 AM

=IF(ISERROR(MATCH(TRUE,A1=A2:A$13,0)),A1,IF(MATCH(TRUE,A1=A2:A$13,0)=1," ",A1))


array entered

Posted by JAF on July 10, 0100 8:51 AM

Re: I need the boolean approach to avoid the 7 limit

Mark

The following link should give you what you need.

http://geocities.com/aaronblood/ExamplesLogic.html