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

[Guest]

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?

 

[Peo Sjoblom]

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
news:[email protected]...

 

[Guest]

Try

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