| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
percentage
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
percentage
Not sure what you're asking...
A1 = 93.5676458748534563 =TRUNC(A1/100,4) Format as PERCENTAGE Returns 93.56% -- Biff Microsoft Excel MVP "ekkeindoha" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
percentage
I have no Idea what you mean by the "& & & & & & feature"
have you tryed formating it as a Percent "ekkeindoha" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
percentage
=--TRUNC(your_formula/100,4)
and format as percentage -- Regards, Peo Sjoblom "ekkeindoha" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
percentage
=TRUNC(--(your_formula/100),4)
is probably better -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... =--TRUNC(your_formula/100,4) and format as percentage -- Regards, Peo Sjoblom "ekkeindoha" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
percentage
Maybe concatenation like =A2&B2 etc
-- Regards, Peo Sjoblom "bj" wrote in message ... I have no Idea what you mean by the "& & & & & & feature" have you tryed formating it as a Percent "ekkeindoha" wrote: 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
percentage
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 "Peo Sjoblom" wrote in message ... =TRUNC(--(your_formula/100),4) is probably better -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... =--TRUNC(your_formula/100,4) and format as percentage -- Regards, Peo Sjoblom "ekkeindoha" wrote in message ... 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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
percentage
Sorry for the confussion.What I meant with the & & & feature are when you
want to form a sentance "Peo Sjoblom" wrote: 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 "Peo Sjoblom" wrote in message ... =TRUNC(--(your_formula/100),4) is probably better -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... =--TRUNC(your_formula/100,4) and format as percentage -- Regards, Peo Sjoblom "ekkeindoha" wrote in message ... 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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
percentage
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%") -- Biff Microsoft Excel MVP "ekkeindoha" wrote in message ... Sorry for the confussion.What I meant with the & & & feature are when you want to form a sentance "Peo Sjoblom" wrote: 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 "Peo Sjoblom" wrote in message ... =TRUNC(--(your_formula/100),4) is probably better -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... =--TRUNC(your_formula/100,4) and format as percentage -- Regards, Peo Sjoblom "ekkeindoha" wrote in message ... 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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
percentage
thx for the info, it works 100%
"Peo Sjoblom" wrote: 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 "Peo Sjoblom" wrote in message ... =TRUNC(--(your_formula/100),4) is probably better -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... =--TRUNC(your_formula/100,4) and format as percentage -- Regards, Peo Sjoblom "ekkeindoha" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| percentage? | Excel Discussion (Misc queries) | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| percentage | Excel Discussion (Misc queries) | |||
| Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel | |||
| Percentage doesn't add up | Excel Discussion (Misc queries) | |||
Linear Mode
