How do I make a comparison chart using formulas in Excel?

Posted on April 20, 2010 by admin

I have an assignment to do where I need to research three different computers and make a comparison chart to find out which is the best computer for the money. The only problem I’m having is that I was never taught how to do this using formulas and/or functions. What formulas would I use to compare different things and find which is the best?

Your question is so general
But let me try
You need first to build the table
Based on the data you have, you need to study formulas like
=A1/A2
or
=
besides IF, SUM, AVERAGE
most of these formulas are in Insert > Functions (if you have Excel2003 or earlier)
or in Formulas tab > Insert Functions (If Excel2007)

Let me know if that worked or not

VBAXLMan

This entry was posted in comparison. Bookmark the permalink.

One Response to How do I make a comparison chart using formulas in Excel?

  1. VBAXLMan says:
    April 20, 2010 at 6:25 am

    Your question is so general
    But let me try
    You need first to build the table
    Based on the data you have, you need to study formulas like
    =A1/A2
    or
    =
    besides IF, SUM, AVERAGE
    most of these formulas are in Insert > Functions (if you have Excel2003 or earlier)
    or in Formulas tab > Insert Functions (If Excel2007)

    Let me know if that worked or not

    VBAXLMan
    References :