Display a string of text with multiple cell values

[paxile2k]

I am trying to create a formula to display a string of text that refers to multiple cells. for example, =If(A1=0,"insert text here" &B1 "insert more text here" &B2 "insert even more text here" &B3, "insert text here" &C1 "Insert text here"). Is this possible? It works fine for one cell value, like ="Total: " &A1

[ncmay]

Put the ampersand on the other side of the cell reference too.

Example:

="insert text here" &B1& "insert more text here"


Norman

[paxile2k]

Thankyou for your response,
That worked beautifully, is there way to round the value of a cell in that display to 2 decimal points also so it will clean up the display of the output?

[ChemistB]

Yes,

Please Login or Register  to view this content.

Does that work for you?

[paxile2k]

Thankyou again for your response,
would the =Text(cell, "#.##") be used in the first formula for displaying text and cell values? or applied to the cell in question?
="insert text here" =TEXT(B1,"#.##)&B1& "insert more text here" ?

[ChemistB]

It would be used in the formula ncmay gave you.

[paxile2k]

thankyou again for your response,
I must be having some difficulty, when i use ncmay's formula, it does display all the info needed, but one of the values it is pulling is displaying with more then 2 decimal places, i am just trying to clean it up to only display 2 dec point within that formula, when i do use ncmays it looks like this:

insert text here 134.8105666666667 insert more text here

the cell it refers to does display itself at 134.81 due to formatting

If i have another cell the uses the =TEXT(B1,"#.##) in C1 for that cell, then use C1 in nmcays formual it works. But i am trying to cut back on adding more cells to display the information then to use in another formula in another cell.

[ChemistB]

Yes, what Excel displays is not always the same as what is in Excel's memory (Important to remember when doing calculations). So, ncmay's formula would be revised to

Please Login or Register  to view this content.

Don't forget the quotes around #.##. They are necessary.

[paxile2k]

Thankyou again for your response and time,
That worked perfectly, thankyou so much for your assistance, it was greatly appreciated. so the & makes all the difference when using the the text formula and cell reference in this

[prashant_110389]

i want to display multiple cell values in a single userform containing a message box...is that possible, m new to vb in excel, but have a craze to learn about it