percentage

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good day,
I need to know how I can enter a percentage from a total into a line by
using the & & & & & & feature.The problem i've got is that it gives me
93.5676458748534563
and all I need are 93.56 %.

Rgds
Jules
 
Not sure what you're asking...

A1 = 93.5676458748534563

=TRUNC(A1/100,4)

Format as PERCENTAGE

Returns 93.56%
 
I have no Idea what you mean by the "& & & & & & feature"
have you tryed formating it as a Percent
 
Doh! the division will take care of the number conversion.

=TRUNC(your_formula/100,4)

or maybe even

=TEXT(TRUNC(your_formula/100,4),"0.00%")

if you want a text value

--


Regards,


Peo Sjoblom
 
Sorry for the confussion.What I meant with the & & & feature are when you
want to form a sentance
 
Use Peo's suggestion of:

=TEXT(TRUNC(your_formula/100,4),"0.00%")

Sort of like this:

="We have a success rate of "&TEXT(TRUNC(your_formula/100,4),"0.00%")
 
thx for the info, it works 100%


Peo Sjoblom said:
Doh! the division will take care of the number conversion.

=TRUNC(your_formula/100,4)

or maybe even

=TEXT(TRUNC(your_formula/100,4),"0.00%")

if you want a text value

--


Regards,


Peo Sjoblom
Click to expand...
 
Back
Top