Stupid Excel an Math

[squall_01]

Im using excel 07 the thing is that I have a pile of work to do an I need to have these numbers 4.25 an 4.50 show up as percentages but when I click the percentage button I get 450% and it will mess up the formula an I tried moving the decimal but to no advial.  WHAY AM I DOING WRONG???

[Dias de verano]

What are you trying to do?

425% times something is the same as 4.25 times that thing.
4.25% times something is the same as 0.0425 times that thing.

[soybean]

Are you applying the % format before or after entering your numbers.  If after, try formatting those cells for % *before* entering the values.  Then, entering 4.25 or 4.50 will display as 4.25% or 4.50%.

Alternatively, where you're applying the % format after entering the number, enter .0425 or .0450 instead of 4.25 or 4.50. 

[squall_01]

Are you applying the % format before or after entering your numbers.  If after, try formatting those cells for % *before* entering the values.  Then, entering 4.25 or 4.50 will display as 4.25% or 4.50%.

Alternatively, where you're applying the % format after entering the number, enter .0425 or .0450 instead of 4.25 or 4.50. 

Thanks thats what I'm tring to do and what I needed   

[squall_01]

It didn't work I tried it.  I have to use a thrid number too 39.50 an it showing up as zero when I do this an I did it both ways an its very irritating

[Dias de verano]

please show the formula and (for the second time of asking) say what you are trying to do!

[squall_01]

This is one of the cells that I need for it,  i'm tring to make these numbers in to a percentage but they come up differntly.  4.25,4.50,39.50 

[Dias de verano]

Are you deliberately not giving any information?

[squall_01]

No I just want to get the stupid things done. 

[soybean]

Read this: http://office.microsoft.com/en-us/excel/HP011612311033.aspx  It confirms what I said about applying the Percent format after vs. before.

It didn't work I tried it.  I have to use a thrid number too 39.50 an it showing up as zero when I do this an I did it both ways an its very irritating

No offense, but I think you need to get a book on Excel.  Visit a library and get a book and/or CD.  Or, go here and buy a book; used books are generally good bargains.

[squall_01]

I have a book the thing was that it was removing the decimal when I clicked the button.

[Dias de verano]

This is what I just did...

1. I typed 0.25 into cell A1

Cell A1 is formatted as "Number" with 2 decimal places.



2. I clicked the percentage button.

Cell A1 now shows "25%" and the cell formatting has changed to "percentage"

(The cat agrees)



Are you saying this does not happen?

I think the problem arises because once you have clicked the percentage button, the format of the cell is changed from number to percentage. If you leave it like that, then type another decimal number in, then you get the result you described. Read Soybean's post again.

[squall_01]

yes but yor decimal place is gone if its like 39.50 it would show only 395%

[Dias de verano]

squall_01, fooling around with Excel when you don't understand what you are doing is not going to help you learn. Start with simple stuff and work up.

[squall_01]

What ever man,  I got it working an it removes the decimal places when you click the percent button if you enter it as a decimal.  I mean no disrespect but I been taking excel since the six grade.  I have a collage course in it, its 07 an I was taught 03 so its some what new to me.  Know for some reason  I take b2*(b3/ (1-b6))  an come up with 253818436.69 an I should have 252733916.  Heres the cells

A2- Units Sold in Prior Year   B2 - 11,459,713
Unit Cost   $13.40
Annual Sales Growth   4.25%
Annual Price Decrease   4.50%
Margin   39.50%