 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Help with logical function
I want to use a conditional formatting statement on a cell to be true if four other conditions are true. I set the conditional formatting to apply if the value of the test cell = 1 Then I'd like to set an IF statement to produce a value 1 for that cell if the four conditions are all true. Thus, for example, if cells A50, A51. A52 and A53 are all zero the conditional format test cell also is true (i.e., has a value of 1). So what is the correct Boolean statement for the test cell?  SignaturePT =AND(A50=0,A51=0,A52=0,A53=0) OR =SUMPRODUCT(--(ABS(A50:A53))=0 best wishes SignatureBernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email >I want to use a conditional formatting statement on a cell to be true if >four other conditions are true. [quoted text clipped - 9 lines] > > So what is the correct Boolean statement for the test cell? my two cents - as long as the data in the target cells are numeric and not text. =--NOT(OR(A50:A53)) > =AND(A50=0,A51=0,A52=0,A53=0) > OR [quoted text clipped - 13 lines] > > > > So what is the correct Boolean statement for the test cell? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.