| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel GURUs help. (How to make program parse more than 1 forumla within a cell)
Alright, so what I'm trying to do is have Excel append multiple custom Error Text in one cell, if there are more than 1 errors. So here's an example. I want all this code parsed within one cell. We'll call it A10 Code: -------------------- =IF(AE1="OK","","ERROR 1") =IF(AE3="OK","","ERROR 2") =IF(AE5="OK","","ERROR 3") -------------------- So, if a single row has three errors (not equal to OK), then I want the cell to report (all within 1 cell): -ERROR 1 ERROR 2 ERROR 3- Are there line breaks that I can use in Excel in order to achieve this? Help! -- Idz21 ------------------------------------------------------------------------ Idz21's Profile: http://www.excelforum.com/member.php...o&userid=30910 View this thread: http://www.excelforum.com/showthread...hreadid=505844 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make an important instruction cell flash in Excel? | Excel Discussion (Misc queries) | |||
| how do i name a excel worksheet and make it appear in cell a1 | Excel Worksheet Functions | |||
| How do you make an excel worksheet cell a perfect square | Excel Discussion (Misc queries) | |||
| How do I make a hard return within a cell in Excel? | New Users to Excel | |||
| How can I make Excel Files save as the text appers in a cell, can. | Excel Discussion (Misc queries) | |||
Threaded Mode
