Need formula to cal percentage of 2 numbers

G

Guest

Hi,

I would like the formula that will compare two numbers and give me the
percentage in the third column.

ex C4 compared to B4 put in cloumn D4 as a percentage,

New to excel and need to know how to put the formula in the cell too?
thanks for hel p in advance
 
P

papou

Hi Mike
In D4 type:
=(C4-B4)/B4
and format your cell as percentage

HTH
Cordially
Pascal
 
G

Gordon

mike b wrote:
|| Hi,
||
|| I would like the formula that will compare two numbers and give me
|| the percentage in the third column.
||
|| ex C4 compared to B4 put in cloumn D4 as a percentage,
||
|| New to excel and need to know how to put the formula in the cell too?
|| thanks for hel p in advance
|| --
|| Mike B

Suggest you get down to your local book store and buy "Excel for Dummies"
 

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

formula referencing a column -> autofilling in a row ??? 2
Formula Help 2
Add to commision formula 1
Formula to compute letter grade based on percentage grade 1
DISPLAY PERSON'S NAME WITH HIGHEST PERCENTAGE OF SALES 4
How Do I create a formula for the percentage below? 4
IF formula to get a percentage increase 2
Add percentage to a whole column of numbers 1

Top