How to use percentage formatting in Excel 2007 (Excel 07-011)

Video 11 in the Excel 2007 Basics series. Shows how to apply percentage formatting and explains common mistakes people make with percentages in Excel.

[Defender]

i was busy that day and doing laundry and cooking. How could I have missed something so easy. Thanks!

[noldaker]

Thank you Mike! This one perplexed several of us yesterday - :)
Thank you for all your video classes too! Helping us Pajama workers that have a need to update our rusty skills. :)

[MikeGroesser]

Hey Jennifer, here's what you can do: multiply the price cells by 0.5. So if you have a price listed in cell A1, in cell A2 you could enter this formula "=A1*0.5" (without the quotation marks). Or, if it's easier for you to remember, you could do "=A1/2" which divides by two. Either way calculates 50% of the price.

[MikeGroesser]

Hi armona1982 -- If I understand your question, by "500.00 Cell" you mean a cell that contains the value 500.00. For example, your total income for the week appears in a cell like B4 or C6. If that's the case, you don't need to use parentheses, so your formula could be =B4*50% or =B4*0.50. You only need to use parentheses when order of operations (mathematically) is an issue. Does that help?

[Defender]

say i have cell a2 is 59 and cell b2 is 45 and cell a3 is 22 and b3 is 19. I would I put make cell a4 be 45 divided into 59, and to be able to copy that formula?

[MikeGroesser]

If I understand, you're trying to make a cell show the percentage change from Q1 to Q2. The reason you're getting 5, 000% is that mathematically, 50 is 5000%. If you want Excel to show the percentage change, you need to divide instead of subtract. So, if 1st Q is cell A1 and 2nd Q is cell B1, you could put this formula into another cell: "=(B1/A1)-1". You can only find a percentage by dividing, and you need to subtract 1 to get the percentage change instead of just a proportion. Hope that helps!

[MikeGroesser]

Hi Sayed, sorry for the delayed response. If I understand your question, you still need to multiply, but only after you add a 1. So, your formula would be "=254*1.0589". Or, if it's formatted as a percentage already, you need to use 105.89% in order to add to the number. Mathematically, 1.0589 is 105.89%, so either works.

[johnr]

Hi Mike.Hoping you can help me with creating the needed formula below using Excel 2010.Have been unsusscessfull!
I need to on a Horizontal cell move to the right performing a different function in each cell.( ) show desired result I need.See example below;
Cell 1 has ($100) as a total. Then minus 10 %. Cell 2=($10) Minis 20% Cell 3=($18)Cell 4($28) Cell 5 to show end balance ($56). Make sense I hope? Are you able to help?
Regards John

[noldaker]

Hi Mike: This simple calculation is driving me crazy --
First quarter $50 2nd Quarter $100 -- Minus 100 minus 50 = $50 --
but when I try to get the total to show percentage change I get 5000% - What am I doing wrong?

[narasimmanpts]

I have values to change decimal to value
Ex 0.05 to convert in Lacs like 5000
0.10 to convert in lacs like 10000

Possible sent video procedure

[sayedlatifusofi]

hi .... i have a problem and i cant find solution please help me out

i want add percentage to my number but not with * multiple i want it to + plus it
like if have 254 i want to add 5.89% to it .... so 254+5.89% = 268
whats the formula for it ....
i did like this =c2+d2 but it does not give me correct answer.

[guatelinda]

ok i have a price list and i want to get 50% of that price for each item how do i do that? h

[MikeGroesser]

If I understand your question, you want to write this formula in cell a4: "=B2/A2" (remove quotes). You can definitely copy that formula, it just depends on what you're trying to do. I have a few videos that might help: How to Use Basic Copy and Paste, How to Copy Cells Using the Fill Handle, and How to Use Absolute and Relative references. You can find these videos on my channel. If those don't help, let me know a little more about how you want to copy and paste, and I'll let you know. Thanks!