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