Need help with percentages


S

sivatummala

Hi all,
I am a newuser in excel, i need help with calculating percentage with
2 different cells.

from cell a1 i want to take 70%, from b1 i want to take 30% out of a
dollar and want it to display in c1,

can anyone please help me with that.

thanks in advance.
 
Ad

Advertisements

T

Tyro

I guess you want in C1: =A1*70% + B1*30% Or something like that.

Tyro
 
S

Sandy Mann

I don't really follow what it is that you are askng. If you want 30% taken
from B1, (ie 70% of the value of B1) then the formula in C1 would be:

=B1*0.7

or

=B1*70%

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
N

Niek Otten

=============================================================
About percentages in Excel

Niek Otten, July 26 2006

In Excel, percentages are stored as fractions; 15% is stored as 0.15, 100% as 1. That makes it easy to calculate with; just
multiply a number with a percentage and you get what you need. No need to divide/multiply by 100. In fact, if you see a
calculation with percentages which has the number 100 somewhere in the formula; be very careful, it might be wrong or at least use
percentages in a way they weren't meant to be used in Excel.
The conversion to a fraction happens automatically if you enter the % sign: if you enter "15%" (without the quotes) the
value will be 0.15 and it will be displayed as 15%. If you then enter 12 in the same cell, two things can happen: It will be the
number 12 or 12%. What happens in your case depends on a setting:
Tools>Options, Edit tab, "Enable automatic percent entry" (only Excel2000 and newer).
All built-in functions of Excel and all the functions in Analysis Toolpak use this representation of percentages: be careful
when supplying parameters to these functions; never use whole numbers (like 8), always use fractions (like 0.08 or, even better,
8%).

Frequently Asked Questions:

Q:
I have A1 and B1. How do I get C1 to show B1 as a percentage of A1?
A:
Formula in C1: =B1/A1, Format as %

Q:
I have A1 and B1. How do I show the difference as a percentage in C1?
A:
As a percentage of A1: =(B1-A1)/A1, Format as %
As a percentage of B1: =(B1-A1)/B1, Format as %
=============================================================


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi all,
| I am a newuser in excel, i need help with calculating percentage with
| 2 different cells.
|
| from cell a1 i want to take 70%, from b1 i want to take 30% out of a
| dollar and want it to display in c1,
|
| can anyone please help me with that.
|
| thanks in advance.
 
Ad

Advertisements

T

Tyro

Percentages in arithmetic generally are fractions as well. "Percent" means
"per", Latin for "by" and "centum", Latin for 100. Therefore "by the
hundred" so, 15% is 15/100 = 0.15 and 234% = 234/100 = 2.34. Let's not make
it seem like it's advanced Calculus. Duh!

Tyro
 

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

Similar Threads

Need help calculating a percentage. 5
Help understan this percentage 4
Percentages 1
percentages 1
Percentages 3
percentages... 2
Percentage 2
Minus Percentage.. 2

Top