Setting Precision when using &"Characters"& in a cell reference
 

I have a cell reference as follows:
=E4 &" "& B7 &"%"

E4 =SUM(T1:T9)/T11
B7 =F2/196

How do I restrict my answer to zero decimal places?
--
FirstVette52

If you want to round to the nearest integer use

=ROUND(E4,0) &" "& ROUND(B7,0) &"%"

you can also use INT and TRUNC although they differ a bit (see help for
them)

--
Regards,

Peo Sjoblom

(No private emails please)


"FirstVette52" <(My User name is Firstvette 52, too) firstvet52@(my ISP
E-mail provider is) netzero.com wrote in message
...
I have a cell reference as follows:
=E4 &" "& B7 &"%"

E4 =SUM(T1:T9)/T11
B7 =F2/196

How do I restrict my answer to zero decimal places?
--
FirstVette52

Try

=E4 &" "& TEXT(B7,"0%")

"FirstVette52" wrote:

I have a cell reference as follows:
=E4 &" "& B7 &"%"

E4 =SUM(T1:T9)/T11
B7 =F2/196

How do I restrict my answer to zero decimal places?
--
FirstVette52