can someone explain how to use functions and formulas on spreadsheets?

  • 0 votes

I'm really confused, help please :)

Posted Sat 8th September, 2012 @ 14:55 by Thegirlwhoknewtoomuch - Team GR

3 Answers

  • 1 vote

Any particular forumlas? I'll say some from the top of my head.

=SUM(E4:I4) = This will return you the sum of all the numbers between the cell E4 and I4.

=MAX(E4:I4) = Returns the hightest value between the cell E4 and I4.

=MIN(E4:I4) = Same as above but minimum value.

There are lots more, just state whatchya' need :)

Answered Sun 9th September, 2012 @ 00:16 by Red
  • 1 vote

http://i1149.photobucket.com/albums/o581/Windowswind/Functions.png

I'm probably too late, but it seemed like no one answered your question :P

Looking at the picture, say for example you wanted to add up cell B2, B3 and B4, then you would type into a cell which you wanted the answer to appear in, the example used in the image was D2

You would type in '=SUM(B2:B4)' and then press enter. The formula bar and the cell work simulatenously, what you type in in the forum bar corresponds with the cell selected.

If you wanted to select only certain cells, instead of using a colon, which is for when the cells are in the same collumn - a way of saying 'B2 to B4' - you could use commas and then you could either type in the cell of just by simply clicking them.

Hope I haven't rambled, and if you already worked this out as it is a month later, than I also apologize :P

Answered Mon 15th October, 2012 @ 21:03 by Windowswind
  • 0 votes

when you do these do you type them into the formula bar or a cell? and do you press enter afterwards, cause i type these in and press enter and nothing is worked out, the formula just stays there in the cell whichout any number in it, bit hard to explain.

Answered Sun 9th September, 2012 @ 09:45 by Thegirlwhoknewtoomuch - Team GR