Two different values in a single cell...

[Patrick]

Hi,

Is it possible to have two different values (coming from
another sheet) in a single cell? For example,

0.87 (0.97)

In that case 0.87 comes from a cell on sheet1 and 0.97
from a cell on sheet2. Thanks for the help.

Patrick,

 

[Guest]

Hi

You can concatenate two results into one cell. This makes it inot a text
cell, however, so you cannot do maths on it quite so easily. To join the
info, just use the CONCATENATE function, or the & sign
=A2&" " &A3
You may also need the TEXT funtion, depending on what format you want the
result to be

 

[Bob Phillips]

Patrick,

Try

=TEXT('Sheet1'!A1,"0.00") &" "&TEXT('Sheet2'!A1,"(0.00)")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

Hi,

Thanks it works very well...

Patrick,

-----Original Message-----
Patrick,

Try

=TEXT('Sheet1'!A1,"0.00") &" "&TEXT('Sheet2'!A1,"(0.00)")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.

 

[Guest]

Hi,

Thanks it works very well...

Patrick,

-----Original Message-----
Patrick,

Try

=TEXT('Sheet1'!A1,"0.00") &" "&TEXT('Sheet2'!A1,"(0.00)")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.