Thread: percentage
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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