concatenate text and formulas in one string

[ccarruth]

This is a challenge..

Have test string "see the # brown dogs" where # is a cell reference - easy enough.

What if # is a formula that needs to use the roundup function like this:

cell a1 cell a2
.66 50

=roundup (a1*a2,0) or 37

So end result being:

"see the "&=roundup(a1*a2,0)&" brown dogs" so display shows:

"see the 37 brown dogs"

can't find syntax that allows for this?

Don't want to use macros, only formulas as shown..is it possible?

C

 

[ccarruth]

Found it..simpy leave off "=" so "&roundup(...)"..thanks.

 

[Khalid NGO]

Hi

Try the following custom format with simple =ROUNDUP(A1*A2,0)
"see the "# "brown dogs"

Regards,