Multiple formula in one cell

[chris007]

Hello,
I put a question here yesterday but i don't think i explained the issue properly hopefully this does

I want to have in one cell 3 inputs from differeent cells based on different criteria the formula that i have oput together below outlines what I would like to happen but obviously does not work at present.

=IF(CS4>0,"RRR",+CS4)
=IF(CU4>0,"MFL ($)",CU4)
=IF(BM4>1,"MFL (HSE)",BM4)

So the values associated with CS4, CU4 and BM4 I would like in the single cell CV4 with the txt preceeding the values and to be on seperate lines within the CV4 cell.

Is this at all possible to do?

Thank you
regards
Chris007

 

[mvptomlinson]

Hi Chris,

Set CV4 to use word wrapping and make it tall enough to accept three rows of data, then use this formula:

=IF(CS4>0,"RRR",CS4)&CHAR(10)&IF(CU4>0,"MFL ($)",CU4)&CHAR(10)&IF(BM4>1,"MFL (HSE)",BM4)

 

[chris007]

MV
Thanks for the info I did not think of the wrap function to force the line item.

Thanks aagin and the formula works fine

Appreciate the time in workign this for me

regards
Chris007