View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
 
Posts: n/a
Default Excel GURUs help. (How to make program parse more than 1 forumla within a cell)

Idz21 wrote...
....
So here's an example. I want all this code parsed within one cell.
We'll call it A10

=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?


A10:
="-"&MID(IF(AE1="OK","",CHAR(10)&"ERROR 1")
&IF(AE3="OK","",CHAR(10)&"ERROR 2")
&IF(AE5="OK","",CHAR(10)&"ERROR 3"),2,256)&"-"