Question using IF function

[executionerhk]

It might be stupid.
I am writing an IF function.

=IF(A1="XXX", "ABC DEF", IF(A1="YYY", "HIJ LMN", IF(A1="ZZZ", "OPQ RST", "N/A")))

What I want is if it is XXX
It will display as follow
ABC
DEF
after ABC I want it to be a new line and the DEF.

same as for
HIJ
LMB

OPQ
RST

Can anyone tell me how can I achieve a new line in a cell when I am using IF function?

If this possible.

Thanks,
Steve

 

[Colin Legg]

Hi,

Try this formula instead:

=IF(A1="XXX", "ABC"&CHAR(10)&"DEF", 
    IF(A1="YYY", "HIJ"&CHAR(10)&"LMN", 
    IF(A1="ZZZ", "OPQ"&CHAR(10)&"RST", "N/A")))

And format the cell alignment to wrap text.

 

[executionerhk]

Done thanks a lot!!
Cheers Colin