Excel GURUs help!

[Idz21]

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

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

 

[SaturnX]

I don't believe there's any easy way to do it, short of writing a macro. Otherwise you'd have to use nested IF statements to account for all 7 possible cases.

--Mark

 

[NeoV]

I think I get your drift.....the easiest way would be to nestle your if statements, like this

=if(A1<>"OK","ERROR1",if(A2<>"OK","ERROR2",if(.....

you get the idea I think.

 

[Idz21]

I actually got it figured out guys. I couldn't nest IF statements because Excel only allows 7. I had to concatenate my statements like so (format cell to Wrap Text):