View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default


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