Urgent

D

deen

Hi I need help in microsoft excel,my problem is "I can't find functio
that calculate data and gives me result in percent.
For example: i have value of 1000 $ and value of 50 $ i need t
calculate it so that my result gives me value how many percent is 50
of 1000 $
 
F

Frank Kabel

Hi
A1: 1000
B1: 50
C1: =B1/A1
and format cell C1 as percentage ('Format - Cells')
 
D

Domenic

deen said:
Hi I need help in microsoft excel,my problem is "I can't find function
that calculate data and gives me result in percent.
For example: i have value of 1000 $ and value of 50 $ i need to
calculate it so that my result gives me value how many percent is 50 $
of 1000 $.

Hi,

Assuming:

A1=50
A2=1000

=A1/A2

Format > Cells > Number > Percentage

Hope this helps!
 
L

Lady Layla

Do your own homework!

: Hi I need help in microsoft excel,my problem is "I can't find function
: that calculate data and gives me result in percent.
: For example: i have value of 1000 $ and value of 50 $ i need to
: calculate it so that my result gives me value how many percent is 50 $
: of 1000 $.
:
:
: ---
:
:
 
G

Guest

After you get your total click on the cell, then click on
format, then style...choose percentage and your answer
should be shown as a percentage. Hope this helps! TJG
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top