Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date Posted: 2015/06/03
Ahmed Maher
by Ahmed Maher , System Administrator & IT Consultant , Axis Solutions (KGL)

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

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

1- Right click on a cell

2- Select - Format Cells - option

3- Choose - Percentage - option

هاشم المشارقة
by هاشم المشارقة , 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
by Firas Shahadi , Human Resources Director , SAUDI UNION

Quick tip: user cell format as Percentage 

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

For getting the percentage value, use the percentage formulae.

sajid Sajid Ali
by 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