How to do percentages in Excel

re: How to do percentages in Excel

Roy — Fri, 07 Oct 2011 09:38:27 GMT

I have a with prices from two different companies and i want to show the difference in prices as a percentage, which i have done, however i would like to formulate the percentage to go green for being cheaper and red for being more expensive, how do i do this, what do i need to add to the formula =(G2-C2)/C2 to make this happen

re: How to do percentages in Excel

Anneliese Wirth — Mon, 05 Sep 2011 23:46:46 GMT

claskowski -- Glad you found the information helpful. I'm a big fan of Sal Khan!

re: How to do percentages in Excel

Anneliese Wirth — Mon, 05 Sep 2011 23:44:47 GMT

Hi Novice: Looks like Gary addressed your question on this post: blogs.office.com/.../use-excel-as-your-calculator.aspx. Check it out and see if it helps.

re: How to do percentages in Excel

claskowski — Mon, 29 Aug 2011 14:42:00 GMT

Thanks for the link to the Khan Academy. And thanks for the above.

re: How to do percentages in Excel

novice — Mon, 29 Aug 2011 05:05:16 GMT

Being a novice to excel and reading soo much it's just going over my head trying to absorb soo much for probably such a simple formula that i cannot formulate.Having a price list for example and 100's of numbers down a page a formula for eg is needed of such as; $80+5%+10%+60%. where the $ will of course change regualrly but not the %'s. Could u please help as to how to do this on excel 2007.

Thank you for your time

re: How to do percentages in Excel

Anneliese Wirth — Mon, 15 Aug 2011 03:05:36 GMT

Hi Nate --

Thanks a million for pointing out the shorter version of the percentage change formula. Fewer keystrokes? Formulas that are easier to read? Yes, please.

Would love to see more of these tips. Keep 'em coming.

- Anneliese

re: How to do percentages in Excel

Nate Oliver — Sun, 14 Aug 2011 21:13:13 GMT

Just to emphasize a point Mike made in his video tutorials, I always use the following format for a percentage change:

End-point/Starting-point - 1

E.g., =B1/A1-1

It's slightly (and I mean Micro) more efficient, but more importantly, it involves less keystrokes. I find it easier to audit functions in large Workbook Applications where the Worksheet functions are shorter, thus making them more transparent, faster to audit to the eye!

re: How to do percentages in Excel

Anneliese Wirth — Wed, 10 Aug 2011 18:22:16 GMT

Hi Danny -

Thanks for stopping by, and for providing a link to your videos. I always like to see what people out in the community are doing. Takes a village, right?

- Anneliese

re: How to do percentages in Excel

Danny Rocks — Tue, 09 Aug 2011 18:29:20 GMT

Hi Anneliese -

Very good explanation - clear and concise. I like it!

When you have a chance check out my more than 200 free Excel Video Tutorials at my website:

www.thecompanyrocks.com

Thanks!

Danny Rocks

re: How to do percentages in Excel

Anneliese Wirth — Thu, 04 Aug 2011 03:03:48 GMT

Indeed. Thanks for pointing that out, Moshe. While we're on the topic, another good shortcut to memorize is Ctrl+Shift+~, which applies the General number format to the cell. This is useful when you want to remove the Percent number format or double-check the cell's underlying value.