Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How can I get the percentage in excel from a specific value?

user-image
Question ajoutée par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date de publication: 2015/06/03
Ahmed Maher
par Ahmed Maher , System Administrator & IT Consultant , Axis Solutions (KGL)

the value multiplied by the amount in percentage  = value*50%

Mohammad Basheer abu ahmad
par Mohammad Basheer abu ahmad , مشرف كمبيوتر ، الإشراف على الموظفين , قطاع عام

1- Right click on a cell

2- Select - Format Cells - option

3- Choose - Percentage - option

هاشم المشارقة
par هاشم المشارقة , Key Account Manager , Advanced United Systems Ltd. ( A member of Taj Holding Group)

Change the cell format to percentage.

find the link below for the details:

http://www.excelfunctions.net/Percentages-In-Excel.html

Firas Shahadi
par Firas Shahadi , Human Resources Director , SAUDI UNION

Quick tip: user cell format as Percentage 

Pankaj Singh- CMRP
par Pankaj Singh- CMRP , Senior Reliability Engineer , Marafeq Qatar

For getting the percentage value, use the percentage formulae.

sajid Sajid Ali
par sajid Sajid Ali , Admin & Accountant , Fast one Rent A Car

Suppose you want to find percentge of value Following formula will b use,Value ÷total value×100= value% Example =(25/100)*100=25%Thnx

More Questions Like This