 |
 | 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 / September 2006Count fields and show 1 or 0
OK guys, I have another problem I will post here and on another post if nobody reads this. I have the same 5 (A2:E2)fields, each with a 1 or 0. What I need this time is that If A2 is 1, then I need A2 plus any 2 (1or true) of the remaining four (B2:E2), to them have the new field box called total to read 1 or true. If A2 is 0(false), then regardless of the other four, the Total field must read 0 or false. Does this make sense? Thanks again! Hi In your Total box =IF(A2=0,0,IF(SUM(B2:E2)>=2,1,0))  SignatureRegards Roger Govier > OK guys, I have another problem I will post here and on another post > if [quoted text clipped - 6 lines] > the Total field must read 0 or false. Does this make sense? Thanks > again! Hi, Wow thanks for the speedy reply! It works like a charm...thanks again Roger! I may have some more questions later...but thanks again...your help is greatly appreciated! > Hi > [quoted text clipped - 16 lines] > > the Total field must read 0 or false. Does this make sense? Thanks > > again! |
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.