percentage

E

ekkeindoha

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
 
T

T. Valko

Not sure what you're asking...

A1 = 93.5676458748534563

=TRUNC(A1/100,4)

Format as PERCENTAGE

Returns 93.56%
 
B

bj

I have no Idea what you mean by the "& & & & & & feature"
have you tryed formating it as a Percent
 
P

Peo Sjoblom

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
 
E

ekkeindoha

Sorry for the confussion.What I meant with the & & & feature are when you
want to form a sentance
 
T

T. Valko

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%")
 
E

ekkeindoha

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