View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Idz21
 
Posts: n/a
Default 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