Excel 2007 Formula Question

Microsoft Microsoft excel 2007 (pc)
August 19, 2009 at 10:40:54
Specs: Windows XP
I am trying to enter a formula to calculate the percentage of G1 and H1 to populate in K1.(This will show how much we won or the competitor won)

Columns G & H will always vary. Can some advise on the correct formula?


1 3000 4000 % of difference

2 5000 2000 % of difference

3 500 820 % of difference

See More: Excel 2007 Formula Question

Report •

August 19, 2009 at 11:37:17
Just a friendly posting tip...

A more relevant subject line would have included the word "percentage". If everyone in this forum used subject lines like Excel 2007 Formula Question then figuring out which thread was related to what issue would be impossible. It would also be very hard to search for specific issues in the archives.

That said, have you looked in the Excel Help files under Calculate Percentages? Excel 2003 offers suggestions for at least 5 different percentage related calculations.

Take a look and see if one of them fits your needs. If not, come on back and we'll see what we can do.

Report •
Related Solutions

Ask Question