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

F

FirstVette52

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?
 
P

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]...
 
Top