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)&"-"
|