How do you set up an excel spreadsheet to calculate a formula?

September 8 2010 by Admin in Microsoft Excel |3 Comments

I need аn simpler way tο сlаrіfу thіѕ tο people whο hаνе never used Microsoft Excel 2007. Yουr hеlр іѕ greatly appreciated.

3 Comments

  • sgtjnlawrence says:
    September 8, 2010 at 3:57 pm

    Well it all depends on what formula you want to setup. A simple one would be =Sum(A1+A2)

  • kan_kst says:
    September 8, 2010 at 4:22 pm

    Once you have opened Excel you will find the menu bar at the top of the dialogue box. That’s the one that has file edit etc.. Clear over to the right you will find help. Open this and look in index for formulas or go to search and type in formulas and search. All the info is there you need to know.

  • siti_vi says:
    September 8, 2010 at 4:46 pm

    in connection with answer(2)

    the GOOD formula should be
    =SUM(A1:A2)
    SUM function with 1 argument refers to a array
    or
    =SUM(A1,A2)
    SUM function with 2 arguments refers to two cells
    or
    =A1+A2
    addition, without using worksheet function

    although SUM(A1+A2) will returns right result, but it is a twice summing.

« »