Decimal Place Problems

  • Thread starter Thread starter Gee
  • Start date Start date
G

Gee

At the bottom is my formula. Cell C4 is the calculation
of 2 cells that gives me a percentage...like 63.91%. My
problem is that rather than coming up with:
"Part A has the faster machine in this test. It is faster
by 63.91%"
I get:
"Part A has the faster machine in this test. It is faster
by 63.9113931222027%"
I've tried re-formating the cells from text to percentage
to general and still it get 13 decimal places rather than
2.
HELP??
=('RTA Box'!H4)&" "&"has the faster machine in this
test."&" "&"It is faster by "&(C4)&"%"
 
try something like this... simply add ROUND(C4,2) where you had C4 -- also
you don't need parens in your original formula;

=('RTA Box'!H4)&" "&"has the faster machine in this test."&" "&"It is
faster by "&ROUND(C4,2)&"%"
 
Also, you don't need
H4&" "&"has the faster.."

you can just add the space to the front of the text string a la
H4&" has the faster.."
 
Try


=('RTA Box'!H4)&" "&"has the faster machine in this
test."&" "&"It is faster by "&TEXT(C4,"0.00%")
 
or even
=('RTA Box'!H4)&" "&"has the faster machine in this test. It is faster by
"&TEXT(C4,"0.00%")


--

HTH

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