 |
 | 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 / October 2006=IF(AE22,"Row incomplete","") How does the "AE" fit in
This formula is in L22, It references MERGED cells: D&E, F&G, H&I, and J&K. If there is input in any but not all of the merged cells I get the row incomplete message, but once all the merged cells are filled the message is not shown. I understand the theory but where does the "AE" fit in to the formula? Thanks, Rick There is probably another formula in AE22 that calculates whether all merged cells are completed.  SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > This formula is in L22, It references MERGED cells: D&E, F&G, H&I, and J&K. > If there is input in any but not all of the merged cells I get the row [quoted text clipped - 3 lines] > Thanks, > Rick
|
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.